-
Hi friends,
In my windowsNT box there was one database, now due to disk crash the database is not there. I have installed windowsNT and Oracle. Now i want to restore whole DB with export backup(latest one), but i don't know the structure of earlier DB (datafiles path and all) so How do i proceed with import ??
I don't have anyother backup except EXPORT.
Thnaks,
-
Hi,
datafiles paths are not important here.
You have to create all tablespaces that were in the old database.
In order to find out their names you may directly look in the dumpfile with an editor or use
Code:
imp user/pwd full=y indexfile=schema.sql
In the schema.sql you'll see the create statements for all objects with tablespace names.
HTH
Ales The whole difference between a little boy and an adult man is the price of toys
-
mebbe replacing IMP with EXP would work!!
-
Originally posted by helpme
mebbe replacing IMP with EXP would work!!
Sleep a bit and try again helpme
Cheers
Angel
-
Hi Ales
*************************************************
imp user/pwd full=y indexfile=schema.sql
In the schema.sql you'll see the create statements for all objects with tablespace names
*************************************************
where to give this command, I think it will start importing data. How can i know the tablespace names and size from export.dmp file ??
Any other way.....? any other suggestions ??
-
lol....aarroyob
yeah..i deff need those..or mebbe need to read more books!!!*rolling eyes*
using the indexfile option doesnt import data,,..just creates a file with the deff!!!
-
-
Upeshp
-----------------------------------------
where to give this command, I think it will start importing data. How can i know the tablespace names and size from export.dmp file ??
-----------------------------------------
You can not find the tablespace related info from the export dump. Simply write IMP command on the C:\ .
Sandy
"Greatest Rewards come only with Greatest Commitments!"
-
Upeshp:
If you open your export dump file, you will find at the very beginning of the tablespace structure you are looking for.
Susan
-
Dear Susan,
Please tell me How to open export dump file, I really don't know.....
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|