Projects - EBS (MOSC)

MOSC Banner

PARTITION EXTENDED OBJECT NAMES CAN BE USED WITH SYNONYMS

edited Jul 3, 2009 2:25AM in Projects - EBS (MOSC) 1 commentAnswered
Hello,

I do not have experiance with partition-extended names. Before starting to use this option I would like to be aware of it restrictions.

Following found in SQL reference document regarding partition-extended names restrictions:

Restrictions on Extended Names Currently, the use of partition-extended and
subpartition-extended table names has the following restrictions:
- No remote tables: A partition-extended or subpartition-extended table name cannot contain
a database link (dblink) or a synonym that translates to a table with a dblink.
To use remote partitions and subpartitions, create a view at the remote site
that uses the extended table name syntax and then refer to the remote

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center