OraFAQ Forum: Server Utilities » Doubts in data restore from one schema to another

Home » RDBMS Server » Server Utilities » Doubts in data restore from one schema to another (10.2.0.3 Enterprise edition,Redhat Linux.)

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

Doubts in data restore from one schema to another [message #582552]

Fri, 19 April 2013 06:48

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

Report message to a moderator

Re: Doubts in data restore from one schema to another [message #582559 is a reply to message #582552]

Fri, 19 April 2013 07:33

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One option is to use EXPDP with QUERY clause.

Report message to a moderator

Re: Doubts in data restore from one schema to another [message #582566 is a reply to message #582559]

Fri, 19 April 2013 08:04

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

Report message to a moderator

Re: Doubts in data restore from one schema to another [message #582594 is a reply to message #582566]

Fri, 19 April 2013 18:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Previous Topic:	How to export global temporary tables?
Next Topic:	SQL Loader and Batch ID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 25 11:51:06 CDT 2025