How do you add a data file to a tablespace?



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

Post New Answer

More Oracle AllOther Interview Questions

When the procedures or packagess become invalidate

3 Answers   TCS,


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

0 Answers   Punjab National Bank,


What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,


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

0 Answers   HCL,


Can We Restore a Table that accidantly dropped.

8 Answers   TCS,






What is auto invoicing? Explain : oracle accounts receivable

0 Answers  


Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,


how can it possibble to see the report output in excel sheet in oracle applications

4 Answers   Oracle, Wipro,


How do you add a data file to a tablespace?

1 Answers  


What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers  


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

0 Answers  


Difference between transaction type and transaction sources. : oracle accounts receivable

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)