Home » RDBMS Server » Server Utilities » Export for one month (Oracle Database 10g,Windows 2003 server)
Export for one month [message #313438] Sat, 12 April 2008 03:24 Go to next message
pankaj.karule
Messages: 6
Registered: April 2008
Location: doha
Junior Member
Dear friends,

I want to create new instance for development so i want only limited days of data in new instance say one month.
Can any one please do tell me how to take the export of only one month or limited days? as my production database size too big.

please do help me...

Thanks

Re: Export for one month [message #313443 is a reply to message #313438] Sat, 12 April 2008 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use "query" clause, if you have a date column and with the same name for all tables...

Regards
Michel
Re: Export for one month [message #313452 is a reply to message #313438] Sat, 12 April 2008 08:45 Go to previous messageGo to next message
pankaj.karule
Messages: 6
Registered: April 2008
Location: doha
Junior Member
Thanks for the reply

unfortunately only some(master tables) tables have date column and transaction table did not have any date column.

will you please do tell me how to take export for one month?

waiting for your reply..

thanks once again
Re: Export for one month [message #313453 is a reply to message #313438] Sat, 12 April 2008 08:53 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
Use "query" clause along with "BETWEEN" reserved word
Re: Export for one month [message #313461 is a reply to message #313452] Sat, 12 April 2008 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case, you have to use complex query in "query" clause.

Regards
Michel
Re: Export for one month [message #313464 is a reply to message #313438] Sat, 12 April 2008 11:16 Go to previous message
pankaj.karule
Messages: 6
Registered: April 2008
Location: doha
Junior Member
thanks for the reply...

i will try your suggestions and will update this post regarding the progress

thanks once again
Previous Topic: Import and export
Next Topic: sqlloader with nologging mode
Goto Forum:
  


Current Time: Mon Dec 05 14:56:24 CST 2016

Total time taken to generate the page: 0.09439 seconds