Home » RDBMS Server » Server Utilities » Size rquired for Export and Import of database
Size rquired for Export and Import of database [message #266481] Tue, 11 September 2007 00:23 Go to next message
darshanmeel
Messages: 44
Registered: June 2007
Location: India
Member
Hi all

Currently Oracle 8.1.7.4 is running on IBM Mainframe.W need to migrate it to Oracle 10g Release2 on IBM AIX server.

Current datbabase size is 35 GB.What should be the disk space on the new database so that export and import will be successful without any issue.

Also i heard that when doing export and import the size on the target database should be double the size of the current datbaase for successful exp/imp.Is that true?

Darshan Singh
Re: Size rquired for Export and Import of database [message #266486 is a reply to message #266481] Tue, 11 September 2007 00:29 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is not true.

It wanted to mean you are not performing network level export/import and in which machine export file is located in that machine you are performing import operation. So need more space for dump file as well as data imported in the tablespaces.

Re: Size rquired for Export and Import of database [message #266487 is a reply to message #266486] Tue, 11 September 2007 00:32 Go to previous messageGo to next message
darshanmeel
Messages: 44
Registered: June 2007
Location: India
Member
Thanks.

But what would be the size for 35GB database on target database?

darshan Singh
Re: Size rquired for Export and Import of database [message #266491 is a reply to message #266487] Tue, 11 September 2007 00:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

But what would be the size for 35GB database on target database?
Depands on your export mode.

Now you trying to upgrade your database then better is create new database on target(10g) and just export schema level from source db(8i) and import schema level target db(10g).


Regards
Mohammed Taj
Re: Size rquired for Export and Import of database [message #266492 is a reply to message #266481] Tue, 11 September 2007 00:41 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I better suggest you to use Transport_Tablespaces feature in this case. No need to worry about space.
Previous Topic: How to trim spaces between strings in SQL Loader
Next Topic: records are not getting loaded in order in 10g ( 8i->10g)
Goto Forum:
  


Current Time: Thu Dec 08 18:07:48 CST 2016

Total time taken to generate the page: 0.12732 seconds