1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How do you add a data file to a tablespace?

Question Posted / guest

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

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

How would you extract DDL of a table without using a GUI tool?

0 Answers  

What would you do with an "in-doubt" distributed transaction?

0 Answers  

What is the difference between Datapump & export/import?

2 Answers  




1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

How to make a replica of existing oracle server to another server?

3 Answers  

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

Explain the concept of the DUAL table.

3 Answers  

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

What is dcl? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories