Database Import

[Upeshp]

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,

[ales]

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

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

[helpme]

mebbe replacing IMP with EXP would work!!

[aarroyob]

Originally posted by helpme
mebbe replacing IMP with EXP would work!!

Sleep a bit and try again helpme

Cheers

Angel

[Upeshp]

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 ??

[helpme]

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!!!

[ramaral]

Ales is correct:

http://metalink.oracle.com/metalink/...1&p_showHelp=1

This may make it a little clearer.

[sandycrab]

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

[srlhome00]

Upeshp:

If you open your export dump file, you will find at the very beginning of the tablespace structure you are looking for.

Susan

[Upeshp]

Dear Susan,

Please tell me How to open export dump file, I really don't know.....

Thanks