alter tablesapce <tablespace_name> add datafile '/data/file/lc

How do you add a data file to a tablespace?

Question Posted / shams tabrez

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How would you determine what sessions are connected and what resources they are waiting for?

1608

where the dff data will be stored

1795

What do you mean by hz_ in customer tables? : oracle accounts receivable

635

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1766

How would you determine who has added a row to a table?

1787

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2386

What is Restricted Mode of Instance Startup in Oracle?

668

What Are Cross Validation & Adi?

677

A scenario for amount correction & how to use amount correction functionality in AP invoices

1642

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

661

Difference between negative and positive adjustments : oracle accounts receivable

615

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

2822

Are These Dff's Flexible?

730

What is the difference between recovery and restoring of the oracle database?

653

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1759