DBA Data[Home] [Help]

SYS.DBMS_COMPRESSION dependencies on DBA_OBJECTS

Line 129: ownname IN dba_objects.owner%type,

125: force an alter table to switch on and then switch off compression on this table/partition.
126: [Where Clause]: An optional where clause supplied to the update statement. */
127:
128: PROCEDURE incremental_compress (
129: ownname IN dba_objects.owner%type,
130: tabname IN dba_objects.object_name%type,
131: partname IN dba_objects.subobject_name%type,
132: colname IN varchar2,
133: dump_on IN number default 0,

Line 130: tabname IN dba_objects.object_name%type,

126: [Where Clause]: An optional where clause supplied to the update statement. */
127:
128: PROCEDURE incremental_compress (
129: ownname IN dba_objects.owner%type,
130: tabname IN dba_objects.object_name%type,
131: partname IN dba_objects.subobject_name%type,
132: colname IN varchar2,
133: dump_on IN number default 0,
134: autocompress_on IN number default 0,

Line 131: partname IN dba_objects.subobject_name%type,

127:
128: PROCEDURE incremental_compress (
129: ownname IN dba_objects.owner%type,
130: tabname IN dba_objects.object_name%type,
131: partname IN dba_objects.subobject_name%type,
132: colname IN varchar2,
133: dump_on IN number default 0,
134: autocompress_on IN number default 0,
135: where_clause IN varchar2 default '');