As title, he is doing Java development, suddenly got this task, not sure how to operate, watch a lot of articles also didn't see entirely appropriate, help you

Background: oracle10g (10.2.4.0), the export file is emp according to the user (not sys) is used to derive the DMP file, the size is close to 50 G, to be sure it made some table partition, now need to put the library exported as a backup to another computer, the same version of the oracle database software on the target machine has well

Now want to import the DMP file, but don't know how to operate,
I see some don't need to create a table space ahead of what the article said;
But to see an article that said:
"Questions about the imp tablespace
1 if there is same as the source environment tablespaces, and imp quato user in table space, the object will be in the same table space and the source environment
2 if there is no consistent and source environment and table space, object generated under the user's default tablespace
If there are 3 and consistent source environment table space, but no quato above the table space, objects are generated on the user's default tablespace
4 but for the following situation, must exist the source and target consistent tablespace, and on a quato
Is partitioned
Is a type table
The Contains the LOB, varrays, or OPAQUE type columns
Has an index - organized table (IOT) overflow segment "

The fourth point does that mean I need to manually set up table space, partition these?

I this repository is miscellaneous, hundreds of tables, part of the big table partition, specific how to operate?
Must be the case:
Manually create a user, and then manually create the same as the original library and partition table space, then use imp command to import? Feel this is very troublesome, 2 it is very easy to input error, is there a more convenient way?

CodePudding user response:

Don't struggle so much, you refer to the original library was built in the corresponding table space and users and authorization,
Then imp import went,
Imp import automatically created when the table structure including partition, imp ordered the Internet a lot,

CodePudding user response:

There is a corresponding table space and the user can pour

CodePudding user response:

Don't want to trouble the most mindless method is built directly the same as the original library table space, name, size, etc., otherwise only built form first and then add or ignore=y data_only=y import

CodePudding user response:

In addition, because is 10 g, then consider using impdp + dblink solution to solve this problem, the most comfortable, want to change table space is also a thing ~ remap_tablespace parameters