Re: EXP-00056: ORACLE error 1017 encountered

Yes I have:
lisg039 :/u01/home/oracle> exp "/as sysdba" file=myfile.dmp log=myfile.log full=y rows=n
LRM-00108: invalid positional parameter value 'sysdba'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help EXP-00000: Export terminated unsuccessfully

The exp utility cannot parse the "/as sysdba" portion of the login? I should just be able to do the "exp / " and that will be recognized as "sysdba."?

Louis.

TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<d1dlbv8v088dg2t7350kp2c73dasf27drs_at_4ax.com>...
> froliol_at_yahoo.com (Louis Frolio) wrote:
>
> >Greetings All, I am trying to do a database export with the following
> >sytax:
> >exp / file=myfile.dmp log=myfile.log full=y rows=n
> >
> >I am logged in as the unix user "oracle" who's primary group is "dba".
> > This is the user that owns the database install. I am running 64 bit
> >Enterprise Edition 8.1.7.4 RDBMS.
> >
> >When I execute the above query I am prompted with the error messages
> >listed above in the subject line of this post.
> >
> >I can successfully use sqlplus logging in as "/as sysdba"?:
> >sqlplus "/as sysba"
> >
> >SQL>
> >
> >I have a password file set up and "remote_login_passwordfile =
> >exclusive" is in the init.ora file. The orapwSID file has the user
> >"sys" in it and the password for the passoword file is the same as the
> >password for the database user "sys".
> >
> >When I look at the view v$pwfile_users:
> >SQL> select * from v$pwfile_users;
> >
> >USERNAME SYSDB SYSOP
> >------------------------------ ----- -----
> >INTERNAL TRUE TRUE
> >SYS TRUE TRUE
> >
> >SQL>
> >
> >and this is correct.
> >
> >Any ideas why I cannot do an export without supplying a username and
> >password would be greately appreciated.
> >
> >Louis.
>
> Have you tried
>
> exp "/as sysba" file=myfile.dmp log=myfile.log full=y rows=n
>
> Only sysdba can do a full export, so you need to 'enable' that role on login...
>
>
>
> ----== 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 Fri May 09 2003 - 14:40:09 CEST