How do you add a data file to a tablespace?

Question Posted / guest

3 Answers
7897 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

What is RAID and what are different types of RAID configurations?

1 Answers

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 the difference between the SQL Loader and IMPORT utilities?

3 Answers

What the different types of replication and why are they used? : sql server DBA

0 Answers

the process of adding a cpu in sql server is called..?

2 Answers TCS,

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

What is the recommended interval at which to run statspack snapshots, and why?