- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Import Database from Windows
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
тАО01-17-2006 02:40 AM
тАО01-17-2006 02:40 AM
i have installed oracle9i database on a HP-UX11.11, and i need to import all the info from another oracle 9i database on a windows server, is it possible? if yes, how can i do it?
i have the dump file created by the exp command, but the imp command fails because there are many things that arent compatible, for example the location of the datafiles...
Can anyone help me please.
Best Regards
Pinki
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 02:46 AM
тАО01-17-2006 02:46 AM
Re: Import Database from Windows
Something like this:
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "DBNAME" RESETLOGS NOARCHIVELOG
MAXLOGFILES xxx
MAXLOGMEMBERS xxx
MAXDATAFILES xxx
MAXINSTANCES xxx
MAXLOGHISTORY xxx
LOGFILE
GROUP 1 (
'/path/to/redo/log/number/one',
'/path/to/mirror'
) SIZE xxxM,
GROUP 2 (
..............
) SIZE 70M
DATAFILE
'/path/to/first/datafile',
'/etc/etc/etc'
CHARACTER SET xxxxxxxxx;
ALTER DATABASE OPEN RESETLOGS;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 02:46 AM
тАО01-17-2006 02:46 AM
Re: Import Database from Windows
can you not just import the user data with the user=(user1,user2..) parameter?
Or are you asking about a complete database move? Are you set up for portable tablespaces?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 02:47 AM
тАО01-17-2006 02:47 AM
Re: Import Database from Windows
It should be possible...
First things you need to tell us:
1- the windows and HP-UX database versions?
2- The Win export utlity and the HP-UX import utility versions?
3- What is the exact command you are using for export?
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 02:49 AM
тАО01-17-2006 02:49 AM
Re: Import Database from Windows
Importing oracle database from windows to unix shouldnt be a problem.
export the full database using exp command from sqlplus
import it using imp in unix at sqlplus after installing and configuring oracle.
You have to make sure of the following..
all required kernel tuning has been done for oracle.
oracle is installed without any erros
all PATH variabled has been set
all datafiles exist in the database created in unix, the locations of the datafiles can differ and it should not be a problem.
Could you get the error details?
With Regards,
Siva
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 02:49 AM
тАО01-17-2006 02:49 AM
Re: Import Database from Windows
Forget the first 2 questions: what is the exact command you are using for export?
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 03:07 AM
тАО01-17-2006 03:07 AM
Re: Import Database from Windows
Im asking for a complete database move.
The windows and HP-UX version are 9.2.0 and 9.2.0.1 respectively
The win import/export utility are the same and the command are:
exp admin/password@siges_hostname FILE=expdat.dmp log=export.log FULL=y
imp sys/password@instance AS SYSDBA FULL=y FILE=expdat.dmp log=import.log
The first error i got is:
. importing objects from user system to user system
IMP-00017: failed with ORACLE 12913 error:
"CREATE TABLESPACE "USERS" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\SIGES\USERS01.dbf' ...."
IMP-00003: Cannot create dictionary managed tablespace
...
I can attach the log file if it is necessary
Best Regards
Pinki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 03:50 AM
тАО01-17-2006 03:50 AM
Re: Import Database from Windows
I think it is better for you to a "User Mode" export as Peter Godron suggested:
exp admin/password@siges_hostname FILE=expdat.dmp log=export.log direct=Y OWNER=(User A,...)
And while the export runs in the source database (Windows) you can create the necessary tablespaces in the destination database (HP-UX):
creare tablespace
datafile '/.../FILE1' SIZE
default storage (
initial 100K
next 50K
minextents 1
maxextents 50
pctincrease 0);
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 03:52 AM
тАО01-17-2006 03:52 AM
Re: Import Database from Windows
It is better not to use direct if you want to export REF, LOB, BFILE or object type columns (which include VARRAYs and nested tables)...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2006 03:47 PM
тАО01-17-2006 03:47 PM
Re: Import Database from Windows
is it feasible for you to precreate all the objects before importing the data?
e.g. tablespaces, tables, views, packages, etc.
if yes, let us know, the steps will be much clearer to define.
kind regards
yogeeraj