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 view would you use to determine free space in a tablespace?

what is sql*loader parameters and where we will use it.

how can we send a concurrent program output to the clients through mail or fax give me example.

What Are Cross Validation & Adi?

1. What is PO rate variance gain and loss?

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

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

difference of using cursor for loop and open,fetch,close.which one is better

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

how to replace not in with not exist?

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

what is correlated subquery

For more Oracle AllOther Interview Questions Click Here