OraFAQ Forum: Server Utilities » Export for one month

Home » RDBMS Server » Server Utilities » Export for one month (Oracle Database 10g,Windows 2003 server)

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

Export for one month [message #313438]

Sat, 12 April 2008 03:24

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

Report message to a moderator

Re: Export for one month [message #313443 is a reply to message #313438]

Sat, 12 April 2008 03:58

Michel Cadot
Messages: 68652
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

Report message to a moderator

Re: Export for one month [message #313452 is a reply to message #313438]

Sat, 12 April 2008 08:45

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

Report message to a moderator