import/expor questions
From: Bob Yeh <yehr_at_itsi.disa.mil>
Date: 1996/06/22
Message-ID: <31CC752A.50C3_at_itsi.disa.mil>#1/1
Date: 1996/06/22
Message-ID: <31CC752A.50C3_at_itsi.disa.mil>#1/1
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 Received on Sat Jun 22 1996 - 00:00:00 CEST