Very true... But * IF * John's solution does not work then reason for mentioned error is because U probably ran "CATEXP.sql" AGAIN after running CATPROC.SQL. Anyway to correct this simply run "%oracle_home%\rdbms\admin\CATRM.SQL" script connected as SYS or INTERNAL.
If CATEXP.SQL was rerun after CATPROC.SQL (this runs CATRM.SQL) the modification made to the EXP_FULL_DATABASE role by CATRM.SQL no longer exist since CATEXP.SQL drops and creates the EXP_FULL_DATABASE role. The privileges granted to the role by CATRM.SQL are necessary to export the resource manager objects. OraCop --- John Thomas <[EMAIL PROTECTED]> wrote: > I think you need a password file on the 9i server to > connect remotely > with SYSDBA privilege. > > Go to $ORACLE_HOME/dbs and use orapwd. You may need > to set an init.ora > parameter along the lines of > remote_password_exclusive or shared > depending upon whether you want multiple users (or > was it databases?) > using the same file to log in remotely as well... > > Cheers, > > John Thomas > > In message > <[EMAIL PROTECTED]>, dist > cash > <[EMAIL PROTECTED]> writes > >I am doing the ORACLE 9iR2 database test and tried > to export form a 8i > >computer to 9iR2 server. I got "ORA-01031: > insufficient privileges". > > > >my export parfile on 8i server is: > > > > > >userid='sys/passwd1@db92 as sysdba' > >file=/tmp/exp_db8i_full.dmp > >buffer=64000000 > >compress=n > >grants=y > >indexes=y > >rows=y > >feedback=10000 > >constraints=y > >consistent=y > >log=exp_db8i_full.log > >full=y > > > > > > > > > >I got: > > > >Export: Release 8.1.7.2.0 - Production on Tue Nov > 26 14:02:57 2002 > > > >(c) Copyright 2000 Oracle Corporation. All rights > reserved. > > > > > >EXP-00056: ORACLE error 1031 encountered > >ORA-01031: insufficient privileges > >Username: > > > > > >Does anyone know why?? > > > >Thanks. > > > >_________________________________________________________________ > >The new MSN 8: smart spam protection and 2 months > FREE* > >http://join.msn.com/?page=features/junkmail > > > >-- > >Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: John Thomas > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
