export not working 2005-07-03 - By J. Dex
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 (See ORA-01741.ora-code.com): 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 (See ORA-02095.ora-code.com): specified initialization parameter cannot be modified
>From: "Hollis, Les" <Les.Hollis@(protected)>
>Reply-To: Les.Hollis@(protected)
>To: <janine@(protected)>, <cemail_219@(protected)>
>CC: <oracle-l@(protected)>
>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@(protected)
>[mailto:oracle-l-bounce@(protected)] On Behalf Of Janine Sisk
>Sent: Sunday, July 03, 2005 4:53 PM
>To: cemail_219@(protected)
>Cc: oracle-l@(protected)
>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 (See ORA-01017.ora-code.com): 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
|
|
