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/
