import problems

From: John Blackburn <jb2_at_qdot.qld.gov.au>
Date: 1995/10/18
Message-ID: <461h8c$81o_at_camelot.qdot.qld.gov.au>#1/1

Hi,

I am trying to import part of a users schema from a full database export. some of the objects already exist, so I just want to import those which don't.

The database I am importing into does not contain all of the users which the objects i am trying to import have grants for.

my import statement looks something like this:

imp dbauser/dbapwd file=expdat.dmp fromuser=myuser rows=n indexes=y ignore=y \

                   grants=n

This used to work when I was running oracle 6.0.36 but now that I am running oracle 7.1.4, this import gives about 500 lines of the following error messages:

IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "ST_AUTH_SEQ" TO "USERA""

IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'USERA' does not exist
IMP-00017: following statement failed with ORACLE error 1917:

"GRANT SELECT ON "ST_AUTH_SEQ" TO "USERB""

IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'USERB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:

"GRANT SELECT ON "ST_AUTH_SEQ" TO "USERC""
IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'USERC' does not exist ...

ST_AUTH_SEQ is a sequence.
My database is running on a SPARC 10 running SunOS 4.1.3 The import program is Release 7.1.4.1.0

QUESTION: Why does imp ignore the grants=n parameter when it comes to sequences? All the other grants are ignored so why aren't the sequence grants ignored? I don't want to import the grants. Thats why I said grants=n!

Any pointers to eliminate this most anoying problem will be gratefully received.

--
 
John Blackburn                           Phone: +61 7 32534634
jb2_at_qdot.qld.gov.au                      Fax:   +61 7 38541194

"Please enclose a stamped, self-addressed ethernet packet with
 all correspondence..."

#include <std_disclaimer.h>

Received on Wed Oct 18 1995 - 00:00:00 CET