Creating a new database from a dump file [message #226693] |
Mon, 26 March 2007 03:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
Hi all,
I need to create a new database from a dump file.
Can you please explain what the different steps are?
I supposed I should download and install Oracle, then run export utility.
Can I extract database name or connexion information from the dump file?
Thanks.
|
|
|
|
|
|
Re: Creating a new database from a dump file [message #229249 is a reply to message #226863] |
Fri, 06 April 2007 04:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
Hi anacedent,
Please how can I know if a dump file is a schema dump or a full dump ?
You say it is not mandatory to know file system structure.
Can you explain what you understand by pre-create table before import ?
Will I really need to create a database after installing Oracle ?
Thanks
|
|
|
|
Re: Creating a new database from a dump file [message #229264 is a reply to message #229256] |
Fri, 06 April 2007 05:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
Thanks Michel.
But is there a way to import only a schema when we have a full dump ?
Also will the strings command work for windows ?
Can you give examples (commands) using indexfile to achieve that ? Also what about other database objects (a part from tables ?).
|
|
|
|
|
|
Re: Creating a new database from a dump file [message #229305 is a reply to message #229304] |
Fri, 06 April 2007 10:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
>Should I care about space problem before importing a full database ?
Yes
> How can I take care of that ?
>Can I import files of previous Oracle versions to older versions ?
Previous to what & older than what
> Form 9i to 10g for example
>Will a full linux dump be useable on windows ?
NO
> Is there a workaround - using indexfile for example ?
Thanks.
|
|
|
|
|
Re: Creating a new database from a dump file [message #229477 is a reply to message #229315] |
Sun, 08 April 2007 16:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
Littlefoot,
Won't we have data files path in the dump file ?
Since data file path on windows can not be the same as the one on linux... I was wondering if it is possible or not.
Will I need to increase some data files before importing (to be sure import will go smoothly) ?
|
|
|
|
Re: Creating a new database from a dump file [message #229587 is a reply to message #229479] |
Mon, 09 April 2007 05:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
anacedent,
I don't really understand. Which tablespaces should I create ?
I've just created a new database. Should I create tablespaces already existing in the dump file ? How will I know those tablespaces (I've only received a full export for an unknown database) ?
|
|
|
Re: Creating a new database from a dump file [message #229589 is a reply to message #229587] |
Mon, 09 April 2007 05:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You have to create the same tablespace as in the dump file because you can't use the instructions in this file to create the tablespaces as the paths are different.
You can get these statements with an "imp show=y rows=n ..." or (iirc) with an indexfile.
Regards
Michel
|
|
|