tablespace dropped

to jmodic.
I wanted to recreate the controlfile with an adition of the datafile dropped in the new controlfile. Its a reply that i had on metalink, in the sqlplus forum post = tablespace dropped .

[Edited by steeve123 on 10-04-2002 at 03:28 PM]

No matter where you've got that advice from, it still won't work. It's as simple as that. That file doesn't belong to anything in the database, your tablespace information was gone from the data distionary the moment you dropped it.

Appart from the proprietary superpower superconfidential TUL (or whatever) utility that other have mentioned, you can't use that remaining file for anything in your database except for reusing it with any DATAFILE REUSE operation. The data in it is lost.

i create an new instance, i import my owner dated 15 august, i aplly the ddl statement since.
Then i close the database.
I take my datafile dated 2 october.
Recreate the controle file and open the database with the tablespace system in the new instance.
will this work?

Okay, how is Oracle supposed to resolve SCN's?

Why don't you try what you're proposing and let us know the results?

see my post...user 8/15 to recover and accept data lost ok...You are lucky if you are not fired.I dont think DBA can drop TBS easily.

ok, dont flip, its not my database, its a client database, and its not even my client, its a client of my client.

I just want to see every solution before telling him the very bad news that he's in deep ****. And have a very bad backup strategy.


If i recreate the controlfile with resetlogs option, will that reset the scn?

Quote:

---

Originally posted by steeve123
ok, dont flip, its not my database, its a client database, and its not even my client, its a client of my client.

I just want to see every solution before telling him the very bad news that he's in deep ****. And have a very bad backup strategy.


If i recreate the controlfile with resetlogs option, will that reset the scn?

---

What ever you have to do is.... simply sit with Backup and Recovery guide of Oracle documentation and learn the concepts. Nothing else can be done now.