Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

Oracle Tips by Burleson

Oracle 10g Convert Clause Restrictions Usage Notes

• You can share read-only tablespaces across a heterogeneous cluster.
   

• Both source and destination databases must be running Oracle Database 10g with the initialization parameter COMPATIBLE set to 10.0 or higher.
   

• A tablespace must have been made read-write at least once in Oracle Database 10g before it can be transported to any other platform. Therefore, any read-only tablespaces (or currently existing transported tablespaces) that exist from a version prior to Oracle Database Oracle10g must be made read-write first on the platform where they were created, before they can be transported to a different platform.
   

• RMAN cannot process user datatypes that require endian conversions. If you need to transport objects built on underlying types that store data in a platform-specific format, such as endian, then use Oracle's Data Pump feature.
   

• Query the view v$transportable_platform  to determine the platforms supported by the RMAN CONVERT command. Cross-platform tablespace transport is only supported when both the source and destination platforms are contained in this view. In Oracle Database 10g, the CONVERT command is only required when transporting between platforms for which the value in v$transportable_platform.endian_format is different. If the endian_format column is the same, the files can simply be copied from the source to the destination machine, no conversion is required.
   

• If conversion is needed, you must run the CONVERT command, either on the source host (using "CONVERT TO" and identifying the destination platform), or on the destination host (where the FROM parameter is not needed, because the source platform is noted in the datafile, and where the TO parameter is not needed because conversion will default to the platform RMAN is running on).
   

• CONVERT does not convert the datafiles in-place, instead, it creates an output file that is readable on the specified platform.

The following are the supported datatypes for the CONVERT Command:

• VARCHAR2

• CHAR
   

• NUMBER

• DATE

• TIMESTAMP

• TIMESTAMP WITH TIME ZONE

• TIMESTAMP WITH LOCAL TIME ZONE

• INTERVAL YEAR MONTH

• INTERVAL DAT TO SECOND

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm