Oracle Streams Streams Components Processes Data Types Captured Streams staging consumption

Oracle Tips by Burleson

Oracle Streams
Chapter 2 - Streams Components and Processes

Data Types Captured

Table 2.1 shows the data types that can be part of Streams staging and consumption.

VARCHAR2	TIMESTAMP WITH LOCAL TIME ZONE
NVARCHAR2	INTERVAL YEAR TO MONTH
NUMBER	INTERVAL DAY TO SECOND
LONG	RAW
DATE	LONG RAW
BINARY_FLOAT	CHAR
BINARY_DOUBLE	NCHAR
TIMESTAMP	CLOB
TIMESTAMP WITH TIME ZONE	NCLOB
TIMESTAMP WITH LOCAL TIME ZONE	BLOB and UROWID

Table 2.1 - Data Types that can be captured

The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma

http://www.rampant-books.com/book_2004_2_streams.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA