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
- 9588 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
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is replication? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server 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.
how does an oracle clusterware manage crs resources?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What types of replication are supported in sql server? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
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 can you implement fine-grained auditing?
