Puzzling import warning

From: Leonard F Clark <lfc_at_zoom.co.uk>
Date: Sat, 23 Sep 2000 16:08:54 GMT
Message-ID: <39ccc438.13202103@125.0.0.1>

A colleague imported (from a full export) recently with ignore=y. She lost a table because she hit rollback segment limit. However, this obviously created the table. She then had a number of errors on that table which basically meant she couldn't grant rights on it to a "generic" user. All other tables imported okay and all grants were applied okay.

Any ideas why the rollback error resulted in inabilty to apply grants as well.

The import was as system user.

The relevant part of the log follows

Len

---

. . importing table                      "PAYMENT"
IMP-00003: ORACLE error 1562 encountered

ORA-01562: failed to extend rollback segment number 43 ORA-01650: unable to extend rollback segment RB18 by 256 in tablespace RBS
IMP-00028: partial import of previous table rolled back: 1286949 rows rolled back
IMP-00017: following statement failed with ORACLE error 1031:
"GRANT ALTER ON "PAYMENT" TO "SOLO_USER""

IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:

"GRANT DELETE ON "PAYMENT" TO "SOLO_USER""

IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:

"GRANT INSERT ON "PAYMENT" TO "SOLO_USER""

IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:

"GRANT SELECT ON "PAYMENT" TO "SOLO_USER""

IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:

"GRANT UPDATE ON "PAYMENT" TO "SOLO_USER""
IMP-00003: ORACLE error 1031 encountered ORA-01031: insufficient privileges
. . importing table "PAYMENT_ALLOCATIONS" 237488 rows imported Received on Sat Sep 23 2000 - 11:08:54 CDT