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

> This would have of course created the users, and your response still
 doesn't
> provide any clue as to what happened.

Yes, Mr. Bakker, it did, for those that own objects. But for those that don't it didn't and that's why I was at a lost, because it DID import the DB, but not everythings are created.

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

Sorry for the inconveniences I caused as a 'newbie'

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

I did come across this, but didn't think it would help me, guess I learn something new!

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

Hmm, I will have to look into this " edit the 'create user' statements " thing...

> 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

Thought about this, but since the password is encrypted, I thought it would have only set the password for the username on the new DB with the encrypted characters... didn't come across anything like what you have put up from my 'research'.

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

I will try this and let you know how it goes, THANKS! Oh, I am not the only one 'entrusted' with the whole migration. I am given the task to learn more about being a DBA-trainee.

> Regards,
>
> Sybrand Bakker, Oracle DBA

Thank you again for your advice and comments!

Sunny Received on Tue May 01 2001 - 10:41:34 CDT