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
internal architecture
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How would you extract DDL of a table without using a GUI tool?
how does an oracle clusterware manage crs resources?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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 functionality does oracle provide to secure sensitive information?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
who owns the operating system files created by the utl_file package?
Why does Oracle not permit the use of PCTUSED with indexes?