How do you add a data file to a tablespace?

Question Posted / guest

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

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

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,

If we issue alter database begin backup. What happens to database?

2 Answers

Explain CREATE DATABASE syntax?

2 Answers

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers Zenith,

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

1 Answers

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

What is a correlated sub-query? : sql server DBA

0 Answers

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers

what is asm?

0 Answers Oracle,

Explain what partitioning is and what its benefit is.

2 Answers

For more DB Administration Interview Questions Click Here