RE: [Q] imp/exp error on 9iR2?

2002-09-28 Thread Deshpande, Kirti
The password may not be a problem here. In 9i, sys must connect 'as sysdba' or 'as sysoper'. So, use 'sys as sysdba' when prompted for username (without the single quotes). If you want to use a parfile, then specify userid='sys/password as sysdba'. Those single quotes are needed and notice

[Q] imp/exp error on 9iR2?

2002-09-27 Thread dist cash
I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c)

Re: [Q] imp/exp error on 9iR2?

2002-09-27 Thread Ray Stell
It would appear you don't know the pw of sys, or maybe the capslock is on ;) If you can sqlplus /nolog can connect and alter the sys pw. Then you will know the sys pw and can use it on imp cmd. $ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002 (c)