Re: Export & Import

Hi,
There are different reasons you may not able to do the import. Check the following.

1. The userid that you are using to import should have unlimited tablespace access in the new schema.Also there should be enough space left in the new tablespaces to create new tables. This might be the reason you are getting this error.
2. Make sure the userid you are using for doing import has CREATE_SESSION privilege, EXP_FULL_DATABASE & IMP_FULL_DATABASE role enabled.
3. If the export is Full database export , use an userid having DBA previlages.
4. The best thing you can do is, create a same set of tablespaces in the new schema before you do import. So that system automatically recognizes the tablespaces while doing import.

This checklist might help you to resolve your import problem.

Best of Luck.
Bhaskara Rao
(s_bhaskara_at_yahoo.com)

Nandakumar wrote:

> Hi,
>
> A table was exported with data from one schema, on oracle 7.1*, on DEC
> and when it was imported on another schema, it failed for not able to
> create the table. The only difference between the two schemas is the
> table on the destination system is on a different TABLESPACE than the
> table on origin schema.
>
> Can anyone give suggestions to resolve this problem?
>
> Thanks a lot.
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Sep 20 1999 - 03:51:25 CEST