Home » RDBMS Server » Server Administration » How do u overwrite a scheme of tables with another schema
How do u overwrite a scheme of tables with another schema [message #163566] Fri, 17 March 2006 04:46 Go to next message
aidi-h
Messages: 45
Registered: November 2005
Member
I was wondering if you could help.
I wish to refresh a schema that contains a number of tables (that contain a particular applications older data tables) with that of another schema (that contain the same tables with more up to date data). how can this be achieved?
Can we use the 'copy' command or simlilar or do we have to use export/import.
Any help would be appreciated.

Report message to a moderator

Re: How do u overwrite a scheme of tables with another schema [message #163595 is a reply to message #163566] Fri, 17 March 2006 07:35 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Export/import will be simpler depending on the volume of data.

Report message to a moderator

Previous Topic: RESETLOGS_CHANGE#
Next Topic: problem with GUI apps
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:44:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.