Home » RDBMS Server » Server Utilities » export tables (windows)
export tables [message #331233] Wed, 02 July 2008 12:59 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member
hi all,

i want to export bunch of tables (20 tables at a time) in a single export.can anybody come up with the statement??

urgent

Report message to a moderator

Re: export tables [message #331234 is a reply to message #331233] Wed, 02 July 2008 13:04 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
exp help=y

pay close attention to the TABLES statement.

Report message to a moderator

Re: export tables [message #331270 is a reply to message #331233] Wed, 02 July 2008 16:37 Go to previous messageGo to next message
gaperumal
Messages: 8
Registered: June 2008
Location: Chennai India
Junior Member
exp username/password@host file='.../file_name.dmp log='.../schema_dt.log tables=('T1','T2','T3'...'T20')

Arangaperumal G
Chennai,India

Report message to a moderator

Re: export tables [message #331285 is a reply to message #331270] Wed, 02 July 2008 21:53 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member
Thanks Arangaperumal

Report message to a moderator

Previous Topic: imp from .rar
Next Topic: Is it possible to import only the master tables?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 02:44:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.