Home » RDBMS Server » Server Utilities » Creating a new database from a dump file
Creating a new database from a dump file [message #226693] Mon, 26 March 2007 03:59 Go to next message
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 #226715 is a reply to message #226693] Mon, 26 March 2007 05:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can't.
You have to:
1/ Install Oracle
2/ Create a database
3/ Import you dump assuming it was a full export and you have the same file system structure

Regards
Michel
Re: Creating a new database from a dump file [message #226861 is a reply to message #226715] Mon, 26 March 2007 15:44 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Hi Michel,
How will I know the file system structure ?
Also do you have a link explaining how to do steps 1 and 2 ?
Thanks
Re: Creating a new database from a dump file [message #226863 is a reply to message #226693] Mon, 26 March 2007 15:52 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>How will I know the file system structure ?
It does not matter becuase you can pre-create table before import
Also do you have a link explaining how to do steps 1 and 2 ?
http://tahiti.oracle.com
contains Oracle complete Doc. set.
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 messageGo to next message
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 #229256 is a reply to message #229249] Fri, 06 April 2007 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ There is no official way, try "strings <your dump file> | head -5", you get it.
2/ You can import with indexfile and get the DDL of your tables, then create them where you want in the new database.
3/ Yes.

Regards
Michel
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 messageGo to next message
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 #229272 is a reply to message #229264] Fri, 06 April 2007 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ fromuser/touser
2/ I don't know
3/ Maybe you should read Utilities documentation, there are plenty of examples.

Regards
Michel
Re: Creating a new database from a dump file [message #229301 is a reply to message #229272] Fri, 06 April 2007 09:51 Go to previous messageGo to next message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Should I care about space problem before importing a full database ?
Can I import files of previous Oracle versions to older versions ?
Will a full linux dump be useable on windows ?
Re: Creating a new database from a dump file [message #229304 is a reply to message #226693] Fri, 06 April 2007 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Should I care about space problem before importing a full database ?
Yes
>Can I import files of previous Oracle versions to older versions ?
Previous to what & older than what.
Please stop using relative adjectives & use absolute version numbers.
>Will a full linux dump be useable on windows ?
NO
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 messageGo to next message
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 #229311 is a reply to message #229305] Fri, 06 April 2007 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You cannot full import but you can import schema per schema using fromuser/touser.
Don't forget to ftp the file in binary mode and not ascii one.

Regards
Michel
Re: Creating a new database from a dump file [message #229315 is a reply to message #229305] Fri, 06 April 2007 10:46 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Previously posted
Will a full linux dump be useable on windows ?

NO


DUMP is, I presume, file which is result of the Oracle's EXPORT utility. If so, I don't quite understand why wouldn't it be possible to import such a file on a different platform?

On Oracle 9i and lower, the only option to migrate the database across platforms is to use Export (on a source database) and Import (on a target database). As far as I know (but it seems that I don't know enough), DMP files are binaries, can be only read by Import utility and are operating system independant. Are they not? What would prevent Import utility to successfully perform FULL import, while schema by schema might work correctly?

10g also offers the Cross-platform transportable tablespaces feature (both Linux and Windows are supported) so this might be another option.
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 messageGo to next message
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 #229479 is a reply to message #226693] Sun, 08 April 2007 19:11 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
If you precreate the tablespaces prior to import, it should work without any problems (assuming enough disk space is available).
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 messageGo to next message
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
Michel Cadot
Messages: 64139
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
Previous Topic: QUERY about DB Solo 2.1
Next Topic: SQL*Loader input file directory and data file dynamic - ?
Goto Forum:
  


Current Time: Thu Dec 08 08:20:19 CST 2016

Total time taken to generate the page: 0.19107 seconds