Interested to Buy Any Domain ? << Click Here >> for more details...
How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
- 4 Answers
- 9764 Views
- I also Faced
- E-Mail Answers
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
Which autogrowth database setting is good? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are the recovery models for a database? : sql server DBA
what is the use of recording information about current session?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the operating modes in which database mirroring runs? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
how does an oracle clusterware manage crs resources?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How do you open a cluster administrator? : sql server DBA
what is asm?
how can you get actual data change values from previous transactions in oracle?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Can you redefine a table online?
