Home » RDBMS Server » Server Utilities » Import from dump (oracle 9i database, Linux(RHEL4))
Import from dump [message #308385] Mon, 24 March 2008 03:23 Go to next message
dhanumolu
Messages: 7
Registered: January 2008
Junior Member
Hi all,

I got a export dump which has to be imported on another database. But unfortunately no details where give with the dump. Could u please let me is there any chance to get the details to import as the dump size is around 200GB.

Thanks in advance.

Regards.
hanumolu
Re: Import from dump [message #308389 is a reply to message #308385] Mon, 24 March 2008 03:28 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

with imp use indexfile=file_name to get ddl of objects within dump.
Re: Import from dump [message #308395 is a reply to message #308385] Mon, 24 March 2008 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you mean you don't know what you have to import?
Strange enough!

Regards
Michel
Re: Import from dump [message #308430 is a reply to message #308395] Mon, 24 March 2008 05:26 Go to previous messageGo to next message
dhanumolu
Messages: 7
Registered: January 2008
Junior Member

Hi Michel,

I need to import the full database, but before that I wanted to know the tablespace, users, roles details.

Is there any way to know the above mentioned details.

Regards.
Hanumolu
Re: Import from dump [message #308434 is a reply to message #308430] Mon, 24 March 2008 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you full import all these are created by the import process.
You can also use the option "show=y".

Regards
Michel
Re: Import from dump [message #308436 is a reply to message #308434] Mon, 24 March 2008 05:35 Go to previous messageGo to next message
dhanumolu
Messages: 7
Registered: January 2008
Junior Member


U mean no need to create any tablespaces, as the dump size is large(200GB) I hope that may cause any errors.
Re: Import from dump [message #308439 is a reply to message #308385] Mon, 24 March 2008 05:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is on how you took the dump not about size.

Size does not matter.
Re: Import from dump [message #308440 is a reply to message #308439] Mon, 24 March 2008 05:54 Go to previous messageGo to next message
dhanumolu
Messages: 7
Registered: January 2008
Junior Member


If the export was taken with full=y then I can import the whole database without creating any tablespaces or users, am I rite.
Re: Import from dump [message #308442 is a reply to message #308385] Mon, 24 March 2008 05:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yes, just invoke the exp full=y command , imp itself will take care.
Re: Import from dump [message #308926 is a reply to message #308442] Tue, 25 March 2008 23:54 Go to previous messageGo to next message
dhanumolu
Messages: 7
Registered: January 2008
Junior Member

Arju,


I couldn't proceed with the import as the dump file is without the extension .dmp It show the type is file. Could u help me out.

Thanks.
hanumolu
Re: Import from dump [message #308967 is a reply to message #308926] Wed, 26 March 2008 01:47 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle does not care about your extension.
The problem is not there.
Copy and paste what you did.

Regards
Michel
Previous Topic: inserting a default date, when input date is blank, via SQL LOADER
Next Topic: IMPORT and EXPORT
Goto Forum:
  


Current Time: Thu Dec 08 23:53:23 CST 2016

Total time taken to generate the page: 0.09654 seconds