Hello,
Can anyone tell me if jaws can generate Oracle create syntax similar to the
following examples? I'm an Oracle DBA and new to the jaws product. I need
to create indexes in tablespaces separate from the data tablespaces. This
isn't difficult in Oracle DDL, but I need to know if jaws can do it.
create table reg.lh_test (
col1 number not null,
col2 varchar2(10),
constraint lh_test_pk primary key (col1,col2)
using index tablespace TSINDEX storage(initial 8M next 8M minextents 1
maxextents 5) )
tablespace TSDATA storage(initial 8M next 8M minextents 1 maxextents 5) ;
create index reg.lh_test_ix1 on lh_test (col2)
pctfree 10 initrans 2 maxtrans 255
storage(initial 8m next 8m minextents 1 maxextents 2147483645
pctincrease 0 freelists 1 freelist groups 1 buffer_pool default
tablespace TSINDEX logging compute statistics ;
Any information or referral to documentation is appreciated. If I've made
something unclear, please let me try again.
Thank you,
Linda Hagedorn
Oracle DBA
Saltare, Inc.
650-345-1200 x239
[EMAIL PROTECTED]
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
