Home » SQL & PL/SQL » SQL & PL/SQL » DATABASE REFRESH
DATABASE REFRESH [message #222685] Mon, 05 March 2007 22:59 Go to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
Hi,
While refreshing the database objects from one schema to another schema what are the points to be noted (say all tables should be migrated, indexes should be created, packages status should be created.....)?

Is there any specific checklist which can help me to keep the schemas in sink.


Thanks in Advance.
Re: DATABASE REFRESH [message #222719 is a reply to message #222685] Tue, 06 March 2007 03:00 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How are you doing this 'refresh'?
If you do an Export/Import, then all this will be taken care of for you.
Re: DATABASE REFRESH [message #222734 is a reply to message #222685] Tue, 06 March 2007 04:33 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
I just did such a thing (schema A from DB "source" used to refresh schema A from DB "target"). I used export / import.

Somehow the datbaselinks were not created.
I did not find out yet why... but it's probably a permissinons issue.

oh... and now I come to think of it....
permissions set by other schema's will not be granted to the schema you import when you do a "fromuser / touser" import.

Maybe it helps you Smile

Best Regards,

Martijn Bos
Re: DATABASE REFRESH [message #222736 is a reply to message #222734] Tue, 06 March 2007 04:35 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If the database links were public ones, then I don't think they'll have been imported for anything less than a full import.

The Log file will contain details of anything that errored during the Import.
Re: DATABASE REFRESH [message #222739 is a reply to message #222736] Tue, 06 March 2007 04:54 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
I guess you are rigth, however this was not a public link.

Since our customer is in the habit of changing several things (like table-names/schema-names /.......) all the time in their databases, I think that in the end of the day something stupid will come up.
So my effort to find out (in this partivuar case is verry minimal Smile )
Re: DATABASE REFRESH [message #222747 is a reply to message #222739] Tue, 06 March 2007 05:16 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I know just what you mean.....
Re: DATABASE REFRESH [message #222814 is a reply to message #222739] Tue, 06 March 2007 08:14 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Most likely the CREATE DATABASE LINK privilege was there so that the link could be created and then subsequently removed, hence preventing the import from creating it.
Re: DATABASE REFRESH [message #222816 is a reply to message #222814] Tue, 06 March 2007 08:39 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
I'm quite sure that it's such a thing.

I stopped looking Smile
Previous Topic: help sql
Next Topic: Counting the most recent record
Goto Forum:
  


Current Time: Sun Dec 11 00:46:13 CST 2016

Total time taken to generate the page: 0.09526 seconds