Home » SQL & PL/SQL » Client Tools » dump in Toad version 9.7.2 (oracle 9i)
dump in Toad version 9.7.2 [message #498765] Fri, 11 March 2011 00:50 Go to next message
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?
Re: dump in Toad version 9.7.2 [message #498769 is a reply to message #498765] Fri, 11 March 2011 01:00 Go to previous messageGo to next message
knw15pwr
Messages: 134
Registered: March 2010
Senior Member
Yes. Using the Export Wizard.
in the DBA menu >> Data Import/Export >> Export Utility Wizard.
Re: dump in Toad version 9.7.2 [message #498771 is a reply to message #498769] Fri, 11 March 2011 01:09 Go to previous messageGo to next message
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
Re: dump in Toad version 9.7.2 [message #498772 is a reply to message #498771] Fri, 11 March 2011 01:11 Go to previous messageGo to next message
Littlefoot
Messages: 21446
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).
Re: dump in Toad version 9.7.2 [message #498782 is a reply to message #498772] Fri, 11 March 2011 02:15 Go to previous message
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 ?
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:
  


Current Time: Sun Nov 18 16:35:51 CST 2018