Re: Puzzling import warning

error message indicate the importing user can not grant privilege on the table belong to someone else.

ORA-01031: insufficient privileges
ted chyn

In article <39ccc438.13202103_at_125.0.0.1>,   lfc_at_zoom.co.uk (Leonard F Clark) wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Sep 23 2000 - 11:45:22 CDT