An index can be created on XML columns

Length must be specified for an XML column

XML columns can be added to existing tables

Triggers can be created on tables with XML columns

SELECT * FROM MYUSER.EMP;

CONNECT TO MYREMOTE; SELECT * FROM MYUSER.EMP;

SELECT * FROM MYUSER.MYREMOTE.EMP;

CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP; SELECT * FROM MYUSER.EMP_ALIAS;

LOB table spaces

Changes in cursor positioning

Acquisition and release of locks

Caching of rolled back statements

It only reads active logs

It always needs archive logs

It can never be processed just from memory

It uses output buffers, active and archive logs