We are using your great tool for automatic SVN-Import. Thanks!
Would it be possible, to add the same section start comment lines (from Table > View > View SQL) to the Export files ?
For example:
-- Create table
-- Add comments to the table
-- Create/Recreate primary, unique and foreign key constraints
-- etc ...
Example:
View SQL
========
-- Create table
create table TEST
(
column1 NUMBER,
column2 VARCHAR2(20)
)
tablespace DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table TEST
is 'Tablename';
-- Add comments to the columns
comment on column TEST.column1
is 'Column1';
comment on column TEST.column2
is 'Column2';
Export User Objects - comments are missing
==========================================
create table TEST
(
column1 NUMBER,
column2 VARCHAR2(20)
)
tablespace DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
comment on table TEST
is 'Tablename';
comment on column TEST.column1
is 'Column1';
comment on column TEST.column2
is 'Column2';
------------------------------
This would be really helpful for us, Thanks!
Would it be possible, to add the same section start comment lines (from Table > View > View SQL) to the Export files ?
For example:
-- Create table
-- Add comments to the table
-- Create/Recreate primary, unique and foreign key constraints
-- etc ...
Example:
View SQL
========
-- Create table
create table TEST
(
column1 NUMBER,
column2 VARCHAR2(20)
)
tablespace DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table TEST
is 'Tablename';
-- Add comments to the columns
comment on column TEST.column1
is 'Column1';
comment on column TEST.column2
is 'Column2';
Export User Objects - comments are missing
==========================================
create table TEST
(
column1 NUMBER,
column2 VARCHAR2(20)
)
tablespace DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
comment on table TEST
is 'Tablename';
comment on column TEST.column1
is 'Column1';
comment on column TEST.column2
is 'Column2';
------------------------------
This would be really helpful for us, Thanks!