- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle unix export --> Windows import both ver...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 01:23 AM
тАО03-25-2003 01:23 AM
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??
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 01:43 AM
тАО03-25-2003 01:43 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 01:52 AM
тАО03-25-2003 01:52 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
C;\set oracle_sid
C:\
svrmgrl
svrmgr>connect internal
svrmgr>alter user
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 01:57 AM
тАО03-25-2003 01:57 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 02:23 AM
тАО03-25-2003 02:23 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 02:37 AM
тАО03-25-2003 02:37 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 02:51 AM
тАО03-25-2003 02:51 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
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
Then u can do
C:\imp system/manager@
Please post the logs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 03:02 AM
тАО03-25-2003 03:02 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 06:23 AM
тАО03-25-2003 06:23 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2003 09:47 AM
тАО03-25-2003 09:47 AM
Re: Oracle unix export --> Windows import both versions the same 8.1.7
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