Home » RDBMS Server » Server Utilities » export/import question
export/import question [message #244939] Thu, 14 June 2007 12:32 Go to next message
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
Re: export/import question [message #244940 is a reply to message #244939] Thu, 14 June 2007 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2.

Regards
Michel
Re: export/import question [message #244941 is a reply to message #244939] Thu, 14 June 2007 12:44 Go to previous messageGo to next message
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.
Re: export/import question [message #244944 is a reply to message #244940] Thu, 14 June 2007 12:47 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
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 Go to previous messageGo to next message
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?
Re: export/import question [message #244949 is a reply to message #244946] Thu, 14 June 2007 12:55 Go to previous messageGo to next message
joy_division
Messages: 4640
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.
Re: export/import question [message #244951 is a reply to message #244939] Thu, 14 June 2007 12:57 Go to previous message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Ok thanks very much for the assistance
Previous Topic: Problems with import
Next Topic: Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4
Goto Forum:
  


Current Time: Mon Dec 05 21:19:19 CST 2016

Total time taken to generate the page: 0.12342 seconds