I explain my problem ,,, I work on oracle version 9.2
I deleted a tablespace (drop tablespace including contents ...)
I kept the datafiles, they are in the directory oradata
Consequence of the drop: the table attached to this tablespace has disappeared.
Step 1: I recreate the tablespace with datafiles in oradata with the reuse option
Step 2: I relaunch the script to create my table
problem: my table is empty. I thought when using the reuse recreated on the relationship between datafile and tablespace and move on recovering the data tables attached to the tablespace. (I say I started in database administration)
Questions:
- How to recover data from my table?
- The datafile in oradate is emptied when you drop the tablespace?
- What does the reuse option, if you can not retrieve data from a datafile? especially that we must again, the size allocated to the datafile
I would like to understand the principle that
Bookmarks