Can you create an intermidiate table? For example, CREATE TABLE data_sample_table AS SELECT * FROM main_table WHERE rownum < 1000 Then you can ZIP data_sample_table table. Note that it is not required to unzip to the table with the same data_sample_table name. You can unzip to any desired table, just overide table name in unzip options. : I'd like to see an option for a table, to limit the percent or number of rows : to be DB Zipped. For a large database, I would like to be able to take a : sample of the data only. : Thanks.
|