Home » RDBMS Server » Server Utilities » IMPORT and EXPORT
IMPORT and EXPORT [message #309195] Wed, 26 March 2008 14:57 Go to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
Hi

i need to export 1-2 weeks of data from Production and import to the development and quality databases for one table UP_SB_LOG table only.

Please let me know how to perform this activity with commands.

Thanks
Anandhi

Report message to a moderator

Re: IMPORT and EXPORT [message #309198 is a reply to message #309195] Wed, 26 March 2008 15:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
All the required information can be found by Reading This Fine Manual.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Report message to a moderator

Re: IMPORT and EXPORT [message #309203 is a reply to message #309198] Wed, 26 March 2008 15:24 Go to previous messageGo to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
if you could help with command to extract 1 or 2 weeks of data. that would help.

Report message to a moderator

Re: IMPORT and EXPORT [message #309205 is a reply to message #309195] Wed, 26 March 2008 15:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
if you are incapable or unwilling to RTFM yourself, why should I waste my time re-posting what is already documented?

Report message to a moderator

Re: IMPORT and EXPORT [message #309208 is a reply to message #309205] Wed, 26 March 2008 15:37 Go to previous messageGo to next message
anandhi80
Messages: 19
Registered: December 2007
Location: Chennai
Junior Member
i am ready to RTFM myself, i need to compelete that task in another 30 minutes. i am very much interested to do RTFM, but now i need the commands to complete the task

Report message to a moderator

Re: IMPORT and EXPORT [message #309209 is a reply to message #309195] Wed, 26 March 2008 15:47 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_control_file.htm#sthref837

Report message to a moderator

Previous Topic: Import from dump
Next Topic: Import without dropping tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 06:38:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.