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
- 9775 Views
- I also Faced
- E-Mail Answers
Answer Posted / bharath
Perform below steps
1) alter database datafile < file_id> offline;
2) alter database create datafile <file_id>;
3) recover datafile <file_id>;
4) alter database datafile <file_id> online;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
how to restore files with rman?
What is replication? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the recovery models for a database? : sql server DBA
what are the performance views in an oracle rac environment?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How would you extract DDL of a table without using a GUI tool?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What is fill factor? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the importance of a recovery model? : sql server DBA
