Hi,

While we run 'create table from sequentail dump' or 'create sequentail dump of a table' in either case it dumps only 100 records and collects any 100 records at a time.

Can we adjust it to dump or to get more than 100 records at a time.

If it is possible, please tell me the procedure.

Thanks in advance.

in your environment set

SSTS_SET_ROWS=1000
RDS_FULL=1000
ORA_MAX_ARRAY_FETCH=1000

Dave

Hi Dave,

small doubt
The parameters given by you should be added in 'db_resource' file or in any other place.

please clarify.


Regards,

db_resource, or unix environment variables.

if it's db_resource then you do

parametername:value

if it's unix environment then it's

PARAMETERNAME=value

note the case difference and colon vs equals.

Dave

thank you very much

... and the array interface has to be activated before you can use ora_max_array_insert oder -fetch.

To do so, ora_init has to be set to something like

ora_init:0101000 in the db_resource file.

The first "1" turns on the array interface.


Regards,

lebowski