Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: EXPORT/IMPORT Problem - Can't get user imported into new DB...

Re: EXPORT/IMPORT Problem - Can't get user imported into new DB...

From: Sunny Yu <sunny_at_medservintl.com>
Date: Mon, 30 Apr 2001 16:59:59 -0400
Message-ID: <terk6f91qu2sc7@corp.supernews.com>

> Sunny Yu wrote:
> >
> > Hi,
> >
> > I am trying to migrate our Oracle 7.1.3 DB to 8.1.6 using export/import.
 I
> > got most of it working, but can't seem to get the users imported?! The
 IMP
> > finished fine and gave only warning messages, but when I check the 8i
 DB,
> > none of the users are imported. Any idea/help will be greatly
 appreciated!
> >
> > Sunny
>
> If the users don't own any objects (like in most application
> datatbases),
> they won't be exported. Extract them, and re-create in 8i.
> --
> Gtrz,
>
> Frank van Bortel

You are right, I was just trying to get all the user/password into the new DB w/o having to go to everyone and ask them for their password... You mentioned "Extract them", mind expanding on that? Thanks in advance.

Sunny Received on Mon Apr 30 2001 - 15:59:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US