Oracle on Linux tips, tutorials and expert advice
Migrating Oracle data on Linux <<previous|next>> :Migrating from Oracle 9i to PostgresSQL 7.3.4 using Ora2PgOracle database backup and recovery
Migrating/upgrading Oracle database from Unix to Linux
By Brian Peasland, Database Administrator, SGT, Inc.
SearchOracle.com
- Shut down the Oracle 7 database.
- STARTUP RESTRICT the Oracle 7 database to ensure no one has access to the database.
- Perform a full export of the Oracle 7 database:
exp userid=system file=my_dump.dmp full=y
- On the new server, precreate your Oracle 10g database.
- FTP the dump file, in binary mode, to the new database server.
- On the new database, precreate any users and tablespaces that you will need.
- Import the entire dump file:
imp userid=system file=my_dump.dmp full=y
09 Jan 2007