Re: identified by values compatibility ?

Another factor to consider (at least it was in the old days) is your machine base. If you moved platforms from a little endian to a big endian (or vice versa) Unix, the hashing of the same values comes up with different results for non-Oracle reasons.

Not a problem I have seen in a while, but doesn't mean it can't happen.

Howard J. Rogers wrote:
> zeb wrote:
> > Hi,
> >
> > I have to import a user (schema) from user8 (8i) to user9 (9i).
> > I created the user9 in the 9i database
> > with identified by values 'XXXXXXX'
> > (gotten from imp show=y )
> > when I try to connect with user9
> > with the password it was in the 8i database
> > I am told that the passowrd is not correct ...
> >
> > Is it a normal behavior ?
> > Why the same crypted password
> > doesn't give the same passord whithin 8i and 9i ?
> >
> > Thanks in advance...
> >
> > Oracle 8i/9i
> > Windows 2000
> >
> >
>
>
> Because what you read in the export dump file is a hash value.... and
do
> you know whether the hash algorithm employed in 9i is the same as the

> one used in 8i? Because I certainly don't. And even if it is the same

> hash algorithm, what do you suppose it is a hash of? Username (yours
are
> different)? Database name (is yours the same?)? The unique DBID
(yours
> will be different)? Database Creation Time?? Oracle Version???
>
> Who knows? Point is, no-one does. But any and all of those could
affect
> what the hash value for the same password would be. So attempting
what
> you're attempting is a brave experiment, but it's now time to stop!
>
> Regards
> HJR
Received on Wed Dec 22 2004 - 10:04:50 CST