Home » RDBMS Server » Server Utilities » Doubts in data restore from one schema to another (10.2.0.3 Enterprise edition,Redhat Linux.)
Doubts in data restore from one schema to another [message #582552] Fri, 19 April 2013 06:48 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Hi,

This message for my clarification,we have two schemas MAD_LIVE and MAD_TEST we want to take data from MAD_LIVE to MAD_TEST for particular period of time.Can you please advice any possible way to import data from MAD_LIVE to MAD_TEST for particular period


eg:-

My SCHEMA MAD_LIVE using from year 2010 till now,we want to take only 2012 data from MAD_LIVE and restore it in MAD_TEST.



Regards,
Anil
Re: Doubts in data restore from one schema to another [message #582559 is a reply to message #582552] Fri, 19 April 2013 07:33 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One option is to use EXPDP with QUERY clause.
Re: Doubts in data restore from one schema to another [message #582566 is a reply to message #582559] Fri, 19 April 2013 08:04 Go to previous messageGo to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Hi Thanks for reply but query clause for particular table can we do for whole schema?because we have more than 10,000 tables in particular schema.

Regards,
Anil
Re: Doubts in data restore from one schema to another [message #582594 is a reply to message #582566] Fri, 19 April 2013 18:05 Go to previous message
BlackSwan
Messages: 21949
Registered: January 2009
Senior Member
>we have more than 10,000 tables in particular schema.
I suspect that you life would be better if the data was actually in Third Normal Form.
Previous Topic: How to export global temporary tables?
Next Topic: SQL Loader and Batch ID
Goto Forum:
  


Current Time: Sun Apr 20 07:46:08 CDT 2014

Total time taken to generate the page: 0.07297 seconds