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 / mallesh
To create datafile,we need the current controlfile or buckup controlfile that recognises the new datafile that was added.
we go to mount stage and create new datafile using command
syntax:
>alter database create datafile;
>alter tablespace <tsname> add datafile '<location>' size;
>alter system switch logfile;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
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 is the default port no on which sql server listens? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you record information about current session?
How would you go about verifying the network name that the local_listener is currently using?
how can you implement fine-grained auditing?
what do you understand by flashback feature of oracle?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what functionality does oracle provide to secure sensitive information?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the different sql server versions you have worked on? : sql server DBA
how can you communicate with operating system files from oracle?
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
how can you find out if a table can be redefined?