Re: Oracle 9i Export Problem

"DOKNIK" <dominiqs_at_o2.co.uk> wrote:

>Hi,
>I am trying to export All the schemas(full export) in an Oracle 9i database
>as user SYS, but it fails with the errors below
>.I am running this on HP.UniX v.11
>
>$ exp sys/passwd file=gensys_21102003.dmp log=exp_gensys_21102003.log
>full=y
>
>Export: Release 9.2.0.3.0 - Production on Wed Oct 22 18:47:35 2003
>
>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
>EXP-00056: ORACLE error 28009 encountered
>ORA-28009: connection to sys should be as sysdba or sysoper
>Username: SYS
>Password:
>
>Is this a new feature on 9i wher SYS is not allowed to do exports anymore or
>is it a known problem.I am also suspecting that ...possibly ..the passwd
>file doesnt exist under the dbs
>directory. and i may need to recreate to recreate the passwd
>file.
>Any suggestions .I am new to Oracle 9i, i have used 8.1.7 and have always
>done exports as SYS without any such problems
>
>Your help would be greatly appreciated.Thanks
>

To connect as sys you need to add the phrase 'as sysdba' or 'as sysoper' to the login.. See the docs..it is fully explained in them - it is new with 9.

But you can export as system/password without the added phrase..   

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu Oct 23 2003 - 11:07:27 CDT