How do you add a data file to a tablespace?

Question Posted / guest

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

Can we take incremental backups in datapump?

1 Answers

what is the use of recording information about current session?

0 Answers Oracle,

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers TCS,

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

1 Answers

Explain the difference between a data block, an extent and a segment.

2 Answers

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers

How to determine the service pack currently installed on SQL Server?

1 Answers

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

0 Answers

Give the stages of instance startup to a usable state where normal users may access it.