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..
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
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…