How do you add a data file to a tablespace?

Question Posted / guest

How do you add a data file to a tablespace?..

Answer / shams tabrez

alter tablesapce <tablespace_name> add
datafile '/data/file/lcoation_01.dbf' size 10m autoextend
on;

Is This Answer Correct ?

3 Yes

0 No

More Oracle AllOther Interview Questions

Explain how to close periods in ar. : oracle accounts receivable

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

How can you enable a trace for a session?

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

can we use lexical perameter in oracle plsql if yes how

What are different types of transactions in ar? : oracle accounts receivable

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

can u give guidance abt packages of plsql

What is $FLEX$ and $PROFILES$?

can we drop dual table

3. Steps in UAT?

For more Oracle AllOther Interview Questions Click Here