Home » Other » Client Tools » How to export/import a table using PL/SQL developer? (PL/SQL developer)
How to export/import a table using PL/SQL developer? [message #473472] Sat, 28 August 2010 16:52 Go to next message
megha6
Messages: 1
Registered: August 2010
Junior Member
Want to know how to export and import table using Pl/Sql develpoer from one database to another.

EDITED by LF: changed topic title. The original was "Effect of not using Indexes." (I guess that it was the result of hijacking another, unrelated topic)

[Updated on: Mon, 30 August 2010 06:09] by Moderator

Report message to a moderator

Re: Effect of not using Indexes. [message #473483 is a reply to message #473472] Sun, 29 August 2010 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation between your question and your title?

Regards
Michel
Re: Effect of not using Indexes. [message #473523 is a reply to message #473483] Mon, 30 August 2010 00:27 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
May be helpful for you.

http://wiki.oracle.com/page/Data+Pump+Export+(expdp)+and+Data+Pump+Import(impdp)
http://wiki.oracle.com/page/Oracle+export+and+import+
http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html

Regards
Ved

[Updated on: Mon, 30 August 2010 00:35]

Report message to a moderator

Re: How to export/import a table using PL/SQL developer? [message #473591 is a reply to message #473472] Mon, 30 August 2010 09:11 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Tools -> Database export

[Updated on: Mon, 30 August 2010 09:16] by Moderator

Report message to a moderator

Re: How to export/import a table using PL/SQL developer? [message #473594 is a reply to message #473591] Mon, 30 August 2010 09:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course, this is only valid if you are not afraid about TOAD bugs.
Razz

Regards
Michel
Re: How to export/import a table using PL/SQL developer? [message #473596 is a reply to message #473594] Mon, 30 August 2010 09:26 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member

Not Toad, it's SQL Developer menu.
Razz

Re: How to export/import a table using PL/SQL developer? [message #473601 is a reply to message #473596] Mon, 30 August 2010 09:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Doh! Answered the wrong forum!

Regards
Michel
Re: How to export/import a table using PL/SQL developer? [message #473616 is a reply to message #473601] Mon, 30 August 2010 12:14 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TOAD? SQL Developer?

I thought that it is PL/SQL Developer the question is about. Isn't it?
Re: How to export/import a table using PL/SQL developer? [message #473618 is a reply to message #473616] Mon, 30 August 2010 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Laughing

Re: How to export/import a table using PL/SQL developer? [message #474250 is a reply to message #473618] Sat, 04 September 2010 00:57 Go to previous message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member


In PLSQL DEVELOPER

TOOLS --> Export Tables and Import Tables are there
Previous Topic: How to Debug and View the Values of DBMS_XMLDOM objects in TOAD v9.0
Next Topic: Oracle9i
Goto Forum:
  


Current Time: Thu Mar 28 06:02:09 CDT 2024