Check selected partition after log on to Invantive Estate

Wiki (en)
,
1

When using an Invantive UniversalSQL-connection with Invantive Estate outside of Invantive Estate itself, the partition of the data is typically set using an on-startup-sql clause.

The correct setting of the partition of Estate-data can be verified using the following Invantive PSQL-block:

declare
  l_partition varchar2;
begin
  execute native 'select SYS_CONTEXT (SYS_CONTEXT (''USERENV'', ''CLIENT_INFO'') || ''_ITGEN'',''partition'') from dual' 
  into l_partition
  datacontainer 'ora'
  ;
  dbms_output.put_line('Partition is ' || l_partition);
end;

The output will be on the DBMS Output tab as for instance:

Partition is 0.