OraFAQ Forum: Client Tools » dump in Toad version 9.7.2

Home » Other » Client Tools » dump in Toad version 9.7.2 (oracle 9i)

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

dump in Toad version 9.7.2 [message #498765]

Fri, 11 March 2011 00:50

vivek_rol
Messages: 65
Registered: February 2009

Member

is it possible to take table dump in .dmp extention format in toad?
if yes then how?

Report message to a moderator

Re: dump in Toad version 9.7.2 [message #498769 is a reply to message #498765]

Fri, 11 March 2011 01:00

knw15pwr
Messages: 134
Registered: March 2010

Senior Member

Yes. Using the Export Wizard.
in the DBA menu >> Data Import/Export >> Export Utility Wizard.

Report message to a moderator

Re: dump in Toad version 9.7.2 [message #498771 is a reply to message #498769]

Fri, 11 March 2011 01:09

vivek_rol
Messages: 65
Registered: February 2009

Member

THNAKS KNW15PWR
i am trying to takine export back of emp table in dmp format through toad as per your guideline provided by u.
but when i am trying to do this ,i am getting following error

Export: Release 10.1.0.4.2 - Production on Fri Mar 11 12:37:22 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist

EXP-00000: Export terminated unsuccessfully

emp table is present in my schema

Report message to a moderator

Re: dump in Toad version 9.7.2 [message #498772 is a reply to message #498771]

Fri, 11 March 2011 01:11

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

Senior Member
Account Moderator

If I may: I'd suggest you to use command line EXP utility. Doing that, you'll *know* what you are doing, what schema you are connecting to, what table(s) you are exporting. This is documentation you should read.

GUI is a great tool, but only if you know how to properly use it (and it seems that you don't know how to use yours).

Report message to a moderator

Re: dump in Toad version 9.7.2 [message #498782 is a reply to message #498772]

Fri, 11 March 2011 02:15

knw15pwr
Messages: 134
Registered: March 2010

Senior Member

Well not sure what you are doing wrong. I just tried it and it works fine.
Which schema are you connected from ? and from which schema are you trying to export ?

Report message to a moderator

Previous Topic:	how to get sql query output into text file without spool statement
Next Topic:	unable to set Font for japanese in Grid option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:18:35 CST 2024