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

Seeing as you don't seem to want to read any manuals...

imp help=y

imp system/manager_at_db full=y commit=y feedback=50000 buffer=1048576 file=export.dmp indexes=n

Then, do another import with indexfile=something.sql and edit the CONNECT statements in that SQL. Then, run that SQL through sql*plus to create the indexes.

"Sunny Yu" <sunny_at_medservintl.com> wrote in message news:terk7n41vmg7db_at_corp.supernews.com...
> >
> > "Sunny Yu" <sunny_at_medservintl.com> wrote in message
> > news:ter5lc73vbtla7_at_corp.supernews.com...
> > > 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
> > >
> > >
> >
> > This post just doesn't provide any clue to resolve your problem.
> > Commandline? You weren't importing with show=y hopefully.
> > What 'warning messages'?
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
>
>
> Ah, as a newbie, I ran the IMP command with most of the default, which
> includes show=y. I know, all the "error" showed and flooded the screen.
> Thanks, and I think the problem is like Frank had pointed out, that most
 of
> the users don't own any objects. I just wanted to get all the users' name
> and password moved to the new DB without having to ask all of them, any
> idea?
>
> Oh, the command I used --> IMP SYSTEM/password_at_dbname
>
> Thanks for your attention,
> Sunny
>
>
>
Received on Tue May 01 2001 - 04:42:25 CDT