Oracle unix export --> Windows import both versions the same 8.1.7

[exrational]

I performed an import that I think succeeded. This was a clean install (typical install) with just the default database created (by default) and account system manager.

the database was exported from unix using:

exp system file=CON0.exp log=CON0.log full=y compress =y consistent=y

and I imported it to windows using:

imp system/manager file=CON0.exp log=import_CON0.log full=y ignore=y commit=y

from the system account:

when i goto connect to the database using system manager i get user / pass incorrect. BUT when i connect using a user account for the imported database I also get user / pass incorrect.

I am pulling my hair out with this one. any help will be really really appreciated

I do not need a full import I only need the table spaces and the data. User accounts are not important so if there is a way of avoiding this issue by not importing user accounts then this may help

i am a bit of a newbie. other than above i did nothing else. is there something I should have done??

[T G Manikandan]

How about resetting those passwords

C;\set oracle_sid
C:\
svrmgrl

svrmgr>connect internal
svrmgr>alter user identified by

Revert

[exrational]

thanks for the very quick reply.
unfortunatly I dont have access to the unix server to perform another export. Only the windows machine and the export file.

is it possible to alter the system account and recover the password / reset it>?

i was thinking
SVRMGR> alter user system....

however oracle is not my strength and I could not think what the command would be. can you help with this?

would this work do you think?

[Yogeeraj_1]

hi,

as oracle user, you would do:
sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Mar 25 14:25:56 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL> alter user system identified by manager;

User altered.

SQL>


hth
Yogeeraj

[exrational]

spot on thankyou

changed the password

HOWEVER

the import has not created the schema table that is needed.

the schema table is called coast

and there is a user account coast:

i got errors when i imported the database.

should i create a user called coast and create the table space coast first??

is this why it may have failed?

[T G Manikandan]

Can you post the errors?

When you imp the dmp file you should first examine

show=y will just do a preview without really doing a import which can tell you what you need to do.

If you are importing to user coast.

Create the user coast

svrmgr>create user coast identified by default tablespace temporary tablespace

Then u can do

C:\imp system/manager@ fromuser= touser=coast file= show=y


Please post the logs

[Yogeeraj_1]

hi,

try:
a. create user coast identified by coast default tablespace tbs_coast temporary tablespace temp;

Assuming: default tablespaces tbs_coast and temp already exists.


b. grant connect, resource to coast;


c. imp system/manager fromuser=coast touser=coast file=CON0.exp

NB. i would not recommend using compress=y when exporting!


hth
Yogeeraj

[exrational]

i cant paste the error cause its shooting through a massive import and the errors fly by so fast.

i can pick out user does not exist errors
object does not exist etc etc

so you suggest creating a user:

then creating a table space

then running the import

correct?

[Yogeeraj_1]

hi,

Yes.

You can also specify the parameter "log=coast_exp.log" to capture all the messages.

which you can post here.

Please check and let us know.

hope this helps!
best reagrds
Yogeeraj