| Bishal |
Posted: May 01, 2008 04:33:23 AM |
Total Post: 207
Joined: Apr, 2008
|
i had a export file for my tablespace USERLOCAL
i gave the following command
c:\>exp system/manager transport_tablespace=y tablespaces=userlocal file=e:\exp.dmp
It worked fine...
Now my tablespace is accidentally dropped how do i recover it..
i gave the command
c:\>imp system/manager transport_tablespace=y tablespaces=userlocal file=e:\exp.dmp
but its not working
PLEASE HELP ME OUT
|
|
|
 http://shaharear.blogspot.com |
| Posted: May 01, 2008 05:08:07 AM |  |
|
Total Post: 128
Joined: Apr, 2008
|
try this ... if it give error please include those error...
imp system/manager TRANSPORT_TABLESPACE=Y DATAFILES=/in/smf/service/dfepva/db/ddfepva_P0_1.dbf TABLESPACES=DFEPVA_0 FILE=DFEPVA_0.dmp
|
|
|
|
|
| Bishal |
| Posted: May 01, 2008 05:20:22 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 12:31:57 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
Hi friends,
I have a doubt....dont know it is worng or not :)
While exporting the tablespace using the transportable_tablespace option,It will export only the metadata of the tablespace.I think it do not export the data in the datafiles.We are copying the datafile manually to the other location.
Then i dont know how he dropped the tablespace,if it is including the datafile or not ?Then how it is recovered ..?If he is only having the export backup ? Correct me ?
Thanks in advance
Gopu
|
|
|
|
|
| vinnu |
| Posted: May 05, 2008 08:15:41 AM | |
|
Total Post: 6
Joined: Mar, 2008
|
The data is finally getting stored on the datafiles.When the tablespace export is taken, the data will be taken frm the datafiles itself.May be he had the datafile and hence was able to get it back.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
