How do you add a data file to a tablespace?

Question Posted / guest

3 Answers
7899 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 to start SQL Server in minimal configuration mode?

1 Answers

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers CTS,

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers Oracle,

what is ora 24313?what is the procedure to exclude that error?

0 Answers

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers TCS,

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

How would you determine the time zone under which a database was operating?

2 Answers

Explain the concept of the DUAL table.