Transfering Database across platforms Windows AIX imp/exp
Hi all,
Just after a quick sanity check and though Id run this by you.
I have 10.2.0.4 database on WIndows 2003 (64 bit) and am transferring it to AIX (64 bit).
I always thought that you had to create the database and tablespaces, and then create all users manually and them export and import each schema.
However I found the following HOWTO article: How to Use Export and Import when Transferring Data Across Platforms or Across 32-bit and 64-bit Servers(DocID277650.1) , and I have inlcuded an excerpt below:
"Scenario 4: Transfer of a database.
The Export and Import utilities are the only method that Oracle supports for moving an existing Oracle database from one hardware platform to another. This includes moving between UNIX and NT systems. In Oracle10g you can use the transportable tablespace feature to migrate a database to a different platform by creating a new database on the destination platform and performing a transport of all the user tablespaces.
Just after a quick sanity check and though Id run this by you.
I have 10.2.0.4 database on WIndows 2003 (64 bit) and am transferring it to AIX (64 bit).
I always thought that you had to create the database and tablespaces, and then create all users manually and them export and import each schema.
However I found the following HOWTO article: How to Use Export and Import when Transferring Data Across Platforms or Across 32-bit and 64-bit Servers(DocID277650.1) , and I have inlcuded an excerpt below:
"Scenario 4: Transfer of a database.
The Export and Import utilities are the only method that Oracle supports for moving an existing Oracle database from one hardware platform to another. This includes moving between UNIX and NT systems. In Oracle10g you can use the transportable tablespace feature to migrate a database to a different platform by creating a new database on the destination platform and performing a transport of all the user tablespaces.
0