How do you add a data file to a tablespace?

Question Posted / guest

1 Answers
3690 Views
I also Faced
E-Mail Answers

How do you add a data file to a tablespace?..

Answer / shams tabrez

alter tablesapce <tablespace_name> add
datafile '/data/file/lcoation_01.dbf' size 10m autoextend
on;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More Oracle AllOther Interview Questions

What is an Oracle database Full Backup?

0 Answers

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers

What type of index should you use on a fact table?

1 Answers

can u give guidance abt packages of plsql

0 Answers Mphasis,

Are These Dff's Flexible?

0 Answers Oracle,

what is semphore explian it?

0 Answers IBM,

what is debit memo and credit memo in AR?

1 Answers

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

What is Tax Categories?

0 Answers

what are the tools used for oracle 10g in real time.

0 Answers IBM,

Explain materialized views and how they are used.

2 Answers

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers

For more Oracle AllOther Interview Questions Click Here