Re: import/expor questions

Bob Yeh (yehr_at_itsi.disa.mil) wrote:
: Hi,
 

: I exported a user from database1 with default tablespaces name "USERS".
: Same user is in database2 and database3 with default tablespace name
: "USER_DATA".
 
: I imported this user to database2 with no problem.
: I imported this user to database3 I get error saying "can not create
: table because tablespace "USERS" does not exist".
 

: I used the same export file with the same parameters to do the import.
 

: Database1 and database2 are Window NT, Oracle 7.1.
: Database3 is Sun Salaris, Oracle 7.2.
 

: Is this because of Oracle versions are different or because of the
: platforms are different?
 

: Any information will be appreciated.
 

: Bob

The tablespace information will be exported only if do the export in FULL database mode. ( with user mode tablespace info will not be exported.)

Because u are trying import to database3, it is trying to create the table in USERS ( becuase export carries object tablespace name). To use the export file:

• have a tablespace USERS
• create all objects (tables, views ) manually.. not advisable.

I hope it will be helpful

Srini Kunamnneni
Consulatant Received on Sun Jun 23 1996 - 00:00:00 CEST