RE: export not working

From: J. Dex <cemail_219_at_hotmail.com>
Date: Sun, 03 Jul 2005 21:50:48 -0400
Message-ID: <BAY106-F9068BA3BEA6F24FBE42E7A5E70@phx.gbl>

The export was done by Oracle on an 8174 database and os_authent_prefix was os_authent_prefix = ""

In 9.2.0.6, I want to do an import of that same export file, but I am unable to change os_authent_prefix so part of the import is failing. Got any ideas of a work around to this or am I just trying to do this the wrong way?

SQL> alter system set OS_AUTHENT_PREFIX = "" SCOPE=SPFILE; alter system set OS_AUTHENT_PREFIX = ""

ERROR at line 1:
ORA-01741: illegal zero-length identifier

SQL> alter system set OS_AUTHENT_PREFIX = " " SCOPE=SPFILE; alter system set OS_AUTHENT_PREFIX = " "

ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

>From: "Hollis, Les" <Les.Hollis_at_ps.net>
>Reply-To: Les.Hollis_at_ps.net
>To: <janine_at_furfly.net>, <cemail_219_at_hotmail.com>
>CC: <oracle-l_at_freelists.org>
>Subject: RE: export not working
>Date: Sun, 3 Jul 2005 17:47:31 -0500
>
>Few simple questions.....
>
>First are you logged in to the second server as the "owner" of the
>oracle install?
>
>Second have you created a DB user with the same name identified
>externally?
>
>
>
>
>
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Janine Sisk
>Sent: Sunday, July 03, 2005 4:53 PM
>To: cemail_219_at_hotmail.com
>Cc: oracle-l_at_freelists.org
>Subject: Re: export not working
>
>I don't know what the problem is, but you should be able to just run
>"exp" with no arguments at all and go into interactive mode. Maybe
>that would work?
>
>Also, be sure to mention what version of Oracle you're using. It
>usually matters.
>
>janine
>
>On Jul 3, 2005, at 1:57 PM, J. Dex wrote:
>
> > What am I missing?
> >
> > On one server, if I put in the following it takes me to interactive
> > export without problem:
> > exp /
> >
> > On another server, if I put the same exact thing in (exp / ) I get
>
> > the error:
> > EXP-00056: ORACLE error 1017 encountered
> > ORA-01017: invalid username/password; logon denied
> >
> > _________________________________________________________________
> > FREE pop-up blocking with the new MSN Toolbar - get it now!
> > http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>--
>http://www.freelists.org/webpage/oracle-l

FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 03 2005 - 20:52:42 CDT