OraFAQ Forum: Server Utilities » export/import question

Home » RDBMS Server » Server Utilities » export/import question

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

export/import question [message #244939]

Thu, 14 June 2007 12:32

lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND

Member

I am trying to export schemas from our remote database to local. These schemas already exist in my local database but need to be refreshed every two weeks for new data. Here are my questions:

1. Do I need to drop these schemas, pre-create the schemas and then import all the tables the schemas speficying the schemas

2. Do I need to simply truncate all the tables, indexes etc to accomplish a good import.

3. Do I need to drop these schemas (using the cascade option) and import these schemas without pre-creating the schemas.

I am looking for the most effective and fastest way of accomplishing this. Please provide any solutions for this

Any help will be appreciated. Thanks Mad

Report message to a moderator

Re: export/import question [message #244940 is a reply to message #244939]

Thu, 14 June 2007 12:43

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

2.

Regards
Michel

Report message to a moderator

Re: export/import question [message #244941 is a reply to message #244939]

Thu, 14 June 2007 12:44

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

These schemas already exist in my local database but need to be refreshed every two weeks for new data.

As you gonna refresh your local database every 2 weeks
then go with your 1 option.

Report message to a moderator

Re: export/import question [message #244944 is a reply to message #244940]

Thu, 14 June 2007 12:47

lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND

Member

Thanks for the response Michel and Dreamz but Michel why have you chosen option 2 over 1. Please I was just wondering. Thanks so much.

[Updated on: Thu, 14 June 2007 12:49]

Report message to a moderator

Re: export/import question [message #244945 is a reply to message #244941]

Thu, 14 June 2007 12:48

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

But 1. implies to recreate all the grants.

Regards
Michel

[Updated on: Thu, 14 June 2007 12:49]

Report message to a moderator

Re: export/import question [message #244946 is a reply to message #244945]

Thu, 14 June 2007 12:51

lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND

Member

Yes. I would have to re-grant the schemas privileges and quotas. Another question: should I drop the schemas do I need to coalesce the tablespaces their objects occupied?

Report message to a moderator

Re: export/import question [message #244949 is a reply to message #244946]

Thu, 14 June 2007 12:55

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

No need to coalesce any tablespaces, unless you are using one of those really old versions of the database from 1900's.

Report message to a moderator

Re: export/import question [message #244951 is a reply to message #244939]

Thu, 14 June 2007 12:57

lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND

Member

Ok thanks very much for the assistance

Report message to a moderator

Previous Topic:	Problems with import
Next Topic:	Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 10:12:04 CDT 2024