asked on

Import feature in Pl/Sql Developer

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

yianniscy84

No you can't. In the dump file there is the table definition that defines explicitly the table name.

sumit2906

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.

P2O

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

ASKER CERTIFIED SOLUTION

j_coreil

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

meera78

ASKER

Good for practice!