Solution : https://service.sap.com/sap/support/notes/1035051 (SAP Service marketplace login required)
Summary :
SAP Note highlights a functionality enhancement with Oracle 10g supporting "Cross-Platform Transportable Tablespaces." This allows for a more efficient and rapid data migration across different Oracle database platforms, aiding in applications or database cloning. Techniques such as export/import, R3load, and DB-Link are augmented by transporting tablespaces directly, involving metadata export/import and operating-system-level data copying (using tools like ftp, scp, rcp, tar). It simplifies handling the exchange of data files between systems with identical "os byte order." Pre-requisites include the independence of tablespaces and identical endianness of source and target systems to avoid data conversion tasks. The note outlines procedural steps and system checks (e.g., using sys.dbms_tts.transport_set_check) to validate transportability and highlight potential errors in the transfer process.
Key words :
data1 converted datafile=/tmp/convert/hp-ux/data_d-ms1_i-4262466042_ts-psapsr3usr_fno-15_0jibjld3 channel ora_disk_1, tablespace_name status ------------------------------ --------- system online undotbs1 online sysaux online temp online users online, sql> create user ops$orams1 identified externally 2 default tablespace psapsr3usr, user ops$orams1 lacks create session privilege, sql> create user ops$orams1 identified externally, ' 3> format '/tmp/convert/hp-ux/%u', end transportable tablespace metadata export export terminated successfully, sql> create user ops$ms1adm identified externally, create user ops$orams1 identified externally error, datafile /oracle/ms1/sapdata1/sr3usr_1/sr3usr
Related Notes :
| 1367451 | Oracle 10g: Transportable Database |
| 1003028 | Enhanced support for database copy in BR*Tools |
| 888210 | NW 7.**: System copy (supplementary note) |
| 777024 | BW3.0 and BW3.1 System copy (supplementary note) |
| 771209 | NetWeaver 04: System copy (supplementary note) |
| 547314 | FAQ: System Copy procedure |
| 89188 | R/3 System copy |
| 82478 | SAP system OS/DB migration |