Hello,
I've got one table containing a nested table. The ddl-statement created with pl/sql-developer looks like this:
create table PDB_CHAINS
(
CHA_ID NUMBER not null,
MOD_ID NUMBER not null,
CHAINID VARCHAR2(2),
SEQRES CLOB,
SEQUENCE CLOB,
RESIDUES RESIDUES
)
tablespace EXTDAT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
What I miss is the nested-table-clause for residues:
... nested table residues.restable store as pdb_residues((primary key (nested_table_id,seqid,insertion,hetflag))organization index)
Recreating my fdatamodel using the script provided by pl/sql developer would thus be not possible. Any solutions?
br,
stephan
I've got one table containing a nested table. The ddl-statement created with pl/sql-developer looks like this:
create table PDB_CHAINS
(
CHA_ID NUMBER not null,
MOD_ID NUMBER not null,
CHAINID VARCHAR2(2),
SEQRES CLOB,
SEQUENCE CLOB,
RESIDUES RESIDUES
)
tablespace EXTDAT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
What I miss is the nested-table-clause for residues:
... nested table residues.restable store as pdb_residues((primary key (nested_table_id,seqid,insertion,hetflag))organization index)
Recreating my fdatamodel using the script provided by pl/sql developer would thus be not possible. Any solutions?
br,
stephan
