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 / shiva
>alter database create datafile < path>;
> alter database recover automatic datafile < path> /<file_id>
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the use of ocr?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Where would you look for errors from the database engine?
How to start SQL Server in minimal configuration mode?
What the different types of replication and why are they used? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How do you open a cluster administrator? : sql server DBA
What is dcl? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you create a user-defined lock?