@EgonHugeist
Well, this is even more interesting in Oracle (than BFILE):
http://psoug.org/reference/collections.html
http://www.orafaq.com/wiki/NESTED_TABLE
Here is an example table for the ZEOS reports an error when opening:
CREATE TABLE SYSTEM.AQ$_QUEUES
(
OID RAW(16),
EVENTID NUMBER NOT NULL,
"NAME" VARCHAR2(30) NOT NULL,
TABLE_OBJNO NUMBER NOT NULL,
USAGE NUMBER NOT NULL,
ENABLE_FLAG NUMBER NOT NULL,
MAX_RETRIES NUMBER,
RETRY_DELAY NUMBER,
PROPERTIES NUMBER,
RET_TIME NUMBER,
QUEUE_COMMENT VARCHAR2(2000),
SUBSCRIBERS SYS.AQ$_SUBSCRIBERS, <-------
MEMORY_THRESHOLD NUMBER,
SERVICE_NAME VARCHAR2(64),
NETWORK_NAME VARCHAR2(256),
CONSTRAINT AQ$_QUEUES_CHECK
UNIQUE(
"NAME",
TABLE_OBJNO)
Michal