constraint is validate.
partition table example01 exchange partition
Moving Data from staging table into fact table using exhange partition operation.
transform example02 split
Continue the example01, the table apr_orders. Spliting a table, you must use
key column. Accroding to the key column, implement split.
transform example01 table function
Table to table, transform the every record of the table. Pipe was used in
this case. Transform do not modify the underly data, only work when you use
it to query the data.
I create a new table, and create new function. Though only four records,
it could explain the function how to work well.
REGEXP example01 a glance of REGEXP
regexp like 'grep' in linux.
sql merge example01
sql merge for synchronize data for different tables.
transport tbs example02 xp => rhel
RHEL5.4(32bit,AL32UTF8,O10g,tbs), It is a good example.
transport tbs exmaple01 reverse teaching meterial
May be it is a reverse teaching meterial here.
External Table Example02 like datapump
Transport and filter data between two database using externtal table.
External Table Example01 create a external table
external table example01, create a external table.
Impdp and Expdp example02 job control
control job and monitoring job for expdp/impdp in Oracle 10g.
Impdp and Expdp example01
oltp => filter => dw , using datapumb in oracle 10g.
dw sqlldr example04 parallel and transformation
transformation and parallel
dw sqlldr example03 a bit of advance
In this example, aim to express how to speed up your sql*loader.
~ disable contstraint,
~ rebuild index after loading data,
~ use position key word
~ loading data to a partition of sales, do not impact other partitions.
~ use direct path loading without logging, speed up but danger.
dw sqlldr example02 basic
sqlldr example01 basic
a simple and typical sqlldr example, load operational system password file to your database.
Change Data Capture
Create a cdc example, most important thing is how to use the package dbms_cdc_publish, dbms_cdc_subscribe.