?
Solved

Import feature in Pl/Sql Developer

Posted on 2010-08-16
5
Medium Priority
?
3,494 Views
Last Modified: 2013-12-19

I am new using Import/Export features in Oracle. Right now, am using Pl/Sql Developer tool. I was working a dummy table to learn the Import feature in this tool.

I understood that "Import Tables"  load data into the same table whatever the source table is..

Eg: I have created .dmp file exporting the data from Test_001 from schema A. I logged into schema B and then used the .dmp file which I exported for importing the data. It loaded the data in the same Test_001 table in Schema B.

Can I use the same .dmp file generated using Oracle export for loading into some table 'X'.. i.e not the table which has the same tablename from where .dmp got generated..

I tried that in Pl/Sql developer tool but it is not giving me option to load the .dmp file into a particular table..

Can someone guide me
0
Comment
Question by:meera78
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 2

Expert Comment

by:yianniscy84
ID: 33449782
No you can't. In the dump file there is the table definition that defines explicitly the table name.
0
 
LVL 7

Expert Comment

by:sumit2906
ID: 33451259
you can try this:
create a view with name Test_001 on table Test_002 in schema B. also make sure that view has same aliases for column names available in export dump table.
now run import with ignore=y option. never tried this, let me know if this works.
0
 
LVL 3

Expert Comment

by:P2O
ID: 33456578
Import/Export (.dmp ) is used by DBA, if you are developer you can use .dmp file to load data, but not through PL/SQL you have to use sqlloader to load the data.
If you are developer and if you want to read flat file then PL/SQL provides UTL_FILE option and SQL gives you external table option.
Read it here : http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch12.htm

0
 
LVL 2

Accepted Solution

by:
j_coreil earned 750 total points
ID: 33460117
Another option is to create a DB Link between the two databases at the schema level to get the data across.

Once the DB Link is created, just do the following on the destination database:

create table <table_name> as Select * from SchemaA.<table_name>@<source database>;

This method will allow you to change the table name in the process as well if you want to "import" the data into a different schema or table than the dump file would create.
0
 

Author Closing Comment

by:meera78
ID: 33504377

Good for practice!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question