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
- 9907 Views
- I also Faced
- E-Mail Answers
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
How would you go about verifying the network name that the local_listener is currently using?
how can you initialize log miner?
Why would you use sql agent? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain materialized views and how they are used.
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 many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what are the performance views in an oracle rac environment?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
