Environment:
Source database: Oracle 11.2.0.4 EE on Solaris
Target database: Oracle 11.2.0.4 on RHEL
The goal is to EXPort, using the older EXP utility, just the metadata from the Source database and IMPort, using the old IMP utility, into the Target database and have only one (1) extent per table.
The two databases are not able to be connected via any network so 'NETWORK_LINK' option cannot be used with Data Pump.
The DMP files cannot be transferred to the Target host since my connection is to the database only (no host access, it's a cloud database).
I used EXP to export the metadata using the ROWS=N option. Full command is below:
exp parfile=metadata.par
Parfile:
userid=user1/<pw>
file=metadata.dmp
log=metadata.log
rows=n
owner=user1
I used IMP to import the metadata into the Target database. Full command is below:
imp system@ABCDEF file=metadata.dmp log=metadata.log fromuser=user1 touser=user1
I was prompted for the SYSTEM password and the import proceeded.
When it completed I saw that for one particular large table that it had created 65 extents and was taking up 4GB of space. This was true (multiple extents) for all tables that used more than 1 extent in the source database.
I was hoping for only one (1) extent per table.
I assumed here that the IMP process was creating enough extents to hold the actual data of the table even though I was only importing the metadata.
Does that sound correct?
I thought maybe using the COMPRESS=y/n parameter on the EXPort would help but it seems that would only have created a single 4GB extent (or tried to anyway).
So, my question is, how do I get only one (1) extent per table using EXP/IMP in my 11.2.0.4 environments?
Thanks very much for all suggestions!
-gary