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
- 9771 Views
- I also Faced
- E-Mail Answers
Answer Posted / nehru
>alter database create datafile 'old path' as 'new path' size
>recover datafile 'datafile id';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
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.
What are the commands used in dcl? : sql server DBA
how can you connect from 10g user to 11g user??
what are the performance views in an oracle rac environment?
what are the benefits of flashback feature?
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.
what is asm?
what is the diffrence between core dba and apps dba?
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 is transparent data encryption? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
what is the use of ocr?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Why would you call update statistics? : sql server DBA
