| Datafile deleted. [message #53254] |
Sun, 08 September 2002 22:16  |
msh
Messages: 11
Registered: July 2002
|
Junior Member |
|
|
Hello All,
I have a doubt.If by some emans i have deleted the datafile and i dont have any backup of that file.But ijust want to create another datafile of the same structure.How i can achieve it.
Thanks a lot.
Rgds,
./mk
|
|
|
|
| Re: Datafile deleted. [message #53255 is a reply to message #53254] |
Mon, 09 September 2002 03:43  |
Depa
Messages: 30
Registered: June 2002
|
Member |
|
|
you got to take the tablespace containing the datafile offline.
Then create new datafile as the same name.
bring the tablespace online.
|
|
|
|
| Re: Datafile deleted. [message #53286 is a reply to message #53255] |
Wed, 11 September 2002 02:55 |
msh
Messages: 11
Registered: July 2002
|
Junior Member |
|
|
|
But how to confirm that the created dAtafiel is of same storage structure. I want the new datafile should have the same storage structure as the old one.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
