| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Import error under VMS
Did you check the default tablespace and temp tablespace for the user who is
importing the data? Does the user have a quota on the RBS tablespace? Drop
this quota and give him or her only quotas on the tablespaces you want to
have the tables and indexes.
That's my $.02,
Ruth
----- Original Message -----
From: Sackwitz, Antje <Sackwitz_at_vst.vossloh.de>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, August 29, 2000 12:14 PM
Subject: Import error under VMS
Hi,
we have a Oracle 8.1.6 database on NT and a 8.0.5 database under Open VMS
7.2-1.
I did a 8.0.5 export of the 8.1.6er database and want to import the data in
my 8.0.5er VMS database.
When I try to do the user import I get imp-00058 error and the message
says, that Oracle tries to write the data in the rollback segment of system
tablespace or cannot attach system's rollback segment to users tablespace.
May user has standard tablespace users and this tablespace has its own
rollbacksegment.
The table definition is imported successfully, but the data isn't due to
above error.
Please mail me directly asap if you have any help/idea at hand.
Regards,
Antje Sackwitz
Tel. +49 431 7109 514 Fax. +49 431 7109 675 eMail sackwitz_at_vst.vossloh.de
====================================
-- Author: Sackwitz, Antje INET: Sackwitz_at_vst.vossloh.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Aug 29 2000 - 12:49:58 CDT
 |
 |