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

What command would you use to encrypt a PL/SQL application?

What do you mean by Oracle MEDIA RECOVERY?

How to clone the database using RMAN back

can we drop dual table

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

as a technical developer in oracle applications which type errors feced in your experience sofar

WHAT IS CARTESIAN PRODUCT?

When the procedures or packagess become invalidate

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

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

For more Oracle AllOther Interview Questions Click Here