How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
Answer Posted / mallesh
To create datafile,we need the current controlfile or buckup controlfile that recognises the new datafile that was added.
we go to mount stage and create new datafile using command
syntax:
>alter database create datafile;
>alter tablespace <tsname> add datafile '<location>' size;
>alter system switch logfile;
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you initialize log miner?
What is the default fill factor value? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How can you control the amount of free space in your index pages? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is the role of dip user in our database?
What is the difference between clustered and non-clustered index? : sql server DBA
What is a correlated sub-query? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
what is logical system in sap basis
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is dcl? : sql server DBA