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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 1 May 2001 12:52:56 +0200
Message-ID: <tet588jnlt5kdd@beta-news.demon.nl>

"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
>
>
>

This would have of course created the users, and your response still doesn't provide any clue as to what happened.
I agree with the sentiment voiced in andy_webby's response, the situation with newbies expecting the newsgroup will take them by the hand and do everything for them is getting worse and worse. I'm responding in this fashion, because you apparently expect I have a crystall ball, and have to guess what error messages you got. If you would have run imp help=y you would have seen the option log=<filename>
This would have created a complete transcript of all actions when used concurrently with show=y, and this would have allowed you to edit the 'create user' statements out.
The other approach, of course, in response to Frank van Bortels reply would have been
select 'create user '||username||' identified by values '''||password||''' default tablespace '||default_tablespace||' temporary tablespace '||temporary_tablespace||';'
from dba_users

in the source database, spool that, and run it on the target database. If you are a newbie, how come you are entrusted with the task to migrate from 7.1 to 8.1?

Regards,

Sybrand Bakker, Oracle DBA Received on Tue May 01 2001 - 05:52:56 CDT

Original text of this message

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