Database Software

Welcome to the forums !

Have you checked the documentation at http://www.oracle.com/technology/documentation/goldengate.html ?

HTH
Srini

Hi Srini,

thanks for your answer.
I'm not sure if i have found the rigth answer. I have found in the documentation following part:


The following data types are currently not supported:
● Character
The filewriter does not currently support multibyte character (NCHAR, NVARCHAR)
data types when writing in ASCII format (which nzload requires as input).
● Date/time
INTERVAL: nzload version 4.5 does not support the INTERVAL data type.
TIME WITH TIME ZONE: Oracle GoldenGate Extract does not support time zone
extraction from Oracle. TIME WITH TIME ZONE can probably supported by
combining/reformatting one or more source columns.

Perfect, but i read these part only in the document: "Oracle® GoldenGate for Flat File Administration Guide"

So i'm a little unsure whether that is the rigth documentation. We would like setup golden gate for our migration from oracle with cross plattform change => HP/UX (Big Endian) to Sun Solaris (Big Endian).

Regards
Mathias

I would suggest you open an SR with Support to see is they can provide any additional information.

HTH
Srini

Hi Srini,

i have got following answer from oracle technical consultant with link to the official documentation wich you have also delivered.

....
Supported data types
Numeric data types
● NUMBER up to the maximum size permitted by Oracle
● BINARY FLOAT
● BINARY DOUBLE
Character data types
● CHAR
● VARCHAR2
● LONG
● NCHAR
● NVARCHAR2
Multi-byte character types
● NCHAR and NVARCHAR2 multi-byte character data types
● Multi-byte data stored in CHAR and VARCHAR2 columns
....


**************************************************************************************************************
Point 2)
Documentation => Limitations of support
● For GoldenGate to support multi-byte character data, the source and target databases
must be identical. Transformation, filtering, and other manipulation are not
supported.


=> Therefor we have open an oracle service request and got these answer:

The "Identical" here means the characterset setting in Database. The OS platform doesn't matter. So to your specific question,
...
Is it possible to use Golden Gate for transfer multi-byte character data between two Oracle 11g databases one on the HP-UX platform and another on SUN Solaris Platform ?
...

As long as the Database characterset defined on both Oracle 11g database are the same, the answer is yes.

**************************************************************************************************************

Hope that helps other people too.

Thanks & Regards
Mathias

GG is wonderful...its a huge improvement over Streams....but just a heads up...there are other limitations you should know about...when I last checked (around 3/2010), compressed tables of any type are not supported. There are seperate bug numbers for GG to support HCC, compress for oltp, and compress for bulk insert...I'm on the list to be notified when these are fixed, but I haven't heard anything yet, so I take that to mean they're still not supported.

Also, AQ table logging will cause an abend, so that's also not supported.

Until the newest version, 11, which very recently came out, in order to move lobs a connection to the database would be made and the data would be pulled directly from the database instead of from the logs...this is ok, except its much slower and it causes overhead in your source database. I've heard in version 11 this has been corrected and its a huge performance boost.

I hope this helps you and others....

- John