OraFAQ Forum: Server Utilities » Oracle Export and Import

Home » RDBMS Server » Server Utilities » Oracle Export and Import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Export and Import [message #72038]

Tue, 25 February 2003 23:40

manohar
Messages: 15
Registered: October 2001

Junior Member

Hi All

I have a databse with 3 schemas
The 3 schemas are used for testing and reporting purposes

I need to transfer data from the production to the backup to one of the schemas

so far I am using imp/exp , but imp/exp takes lot of time as some of the tables are huge

Is there any other way to speedup this process?

Thanks in advance

Manohar

Report message to a moderator

Re: Oracle Export and Import [message #72044 is a reply to message #72038]

Wed, 26 February 2003 05:33

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

usually export and import is the simplest way.
May be, u can look into tuning ur export import process.

Report message to a moderator

Re: Oracle Export and Import [message #72051 is a reply to message #72038]

Wed, 26 February 2003 20:18

manohar
Messages: 15
Registered: October 2001

Junior Member

Thanks Mahesh

Any URL or resources to tune the Imp/exp process

Manohar

Report message to a moderator

Re: Oracle Export and Import [message #72100 is a reply to message #72038]

Fri, 07 March 2003 21:54

luqy
Messages: 1
Registered: March 2003

Junior Member

if you are using oracle8.1.6,maybe you can increase JAVA_POOL_SIZE parameter,it is a bug in oracle8.1.6

Report message to a moderator

Previous Topic:	Default Commit Count in SqlLoader
Next Topic:	Oracle Redunduncy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 19:59:38 CDT 2024