How do you add a data file to a tablespace?

Question Posted / guest

3 Answers
6829 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / hemant shrimali (dba)

alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;

Is This Answer Correct ?

8 Yes

1 No

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

Answer / vinoth kumar

alter tablespace <tablespacename> add datafile 'u01
\oradata\db\test01.dbf' size 10m autoextend on next 5m
maxsize 50m

in prodution database autoextend off is to be avoid.

Is This Answer Correct ?

2 Yes

0 No

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

Answer / suman

alter database tablespace ts1 add datafile
'/u01/oradata/directory name/ts1.dbf' size 5m autoextend on;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB Administration Interview Questions

How do you tell what your machine name is and what is its IP address?

4 Answers

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

Datapump backup steps?

1 Answers

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

Oracle 11g new features?

2 Answers

how can you find out if a table can be redefined?