Re: EXP-00056: ORACLE error 1017 encountered

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 Thu May 08 2003 - 21:48:19 CEST