Skip to main content

Search

Welcome to Tibero GTS!

Error 8033 Occurs When a User Without DBA Privileges Executes Table tbexport

Document Type | Troubleshooting

Category | Utility

Applicable Product Version | 6FS07

Document Number | TUTTS001

 

Issue

This explains the phenomenon where error 8033 occurs when a user without dba privileges executes table tbexport on the Tibero 6 FS07_CS_2005 (build 194603) binary. 

Note
Error 8033 occurs when executing tbexport from a regular DB account, and it is an issue that happens when referencing the views dba_part_indexes and dba_idx_partitions. 

 

TEST

[Scenario]

SQL>conn sys/tibero
=================
SQL>create tablespace TS_DATA1 datafile '/home/tibero/tibero6/database/tibero/ts_data1.dtf' size 10M autoextend on;
SQL>create tablespace TS_DATA2 datafile '/home/tibero/tibero6/database/tibero/ts_data2.dtf' size 10M autoextend on;
SQL>create user peter identified by peter;
SQL>grant connect, resource to peter;


SQL>conn peter/peter
=================
SQL>drop table dept;
SQL>create table dept (deptno varchar(30) not null,
dname varchar(30), 
city varchar(30) 
) tablespace TS_DATA1 ;


SQL>alter table dept add primary key (deptno);
SQL>create index ix_dname on dept(dname) tablespace TS_DATA1 ;


SQL>insert into dept values('10','ACC','SEOUL');
SQL>insert into dept values('20','SEL','PUSAN');
SQL>insert into dept values('30','MAN','TAEGU');
SQL>commit;


SQL>drop table emp;

SQL>create table emp (empno varchar(30) not null,
ename varchar(30), 
deptno varchar(30) not null,
email varchar(30)
) tablespace TS_DATA1 ;

SQL>alter table emp add constraint pk_emp primary key (empno);
SQL>alter table emp add constraint fk_emp foreign key (deptno) REFERENCES dept(deptno); 


SQL>create index ix_ename on emp(ename) tablespace TS_DATA1 ; 
SQL>insert into emp values('001','PJH','10','naver');
SQL>insert into emp values('002','XXH','10','daum');
SQL>insert into emp values('003','KIM','20','paro');
SQL>insert into emp values('004','HON','20','LG');
SQL>insert into emp values('005','TWO','30','SAM');
SQL>commit;


SQL>select * from emp;
SQL>select * from dept;

 

[Executing tbexport]

$ tbexport username=peter password=peter sid=tibero file=/tmax/test/273931/exp273931.dat table=emp,dept logdir=/tmax/test/273931/273931.log loglvl=debug 

tbexport 6.0


Copyright 2015 TmaxData Co., Ltd. All Rights Reserved.


the TABLE: emp,dept: Thu Nov 11 16:32:41 KST 2021
Export character set: MSWIN949
Export national character set: UTF-16
exporting table: "PETER"."EMP"
exporting table: "PETER"."DEPT"
[1] PETER.DEPT 3 rows exported.
[0] PETER.EMP 5 rows exported.
java.sql.SQLException: JDBC-8033:Specified schema object was not found.
at line 11, column 15 of null:
from dba_part_indexes a,
^
at com.m.internal.jdbc.err.MInternalError.makeSQLException(Unknown Source)
at com.m.internal.jdbc.err.MInternalError.newSQLException(Unknown Source)
at com.m.internal.jdbc.msg.common.MInternalMsgError.readErrorStackInfo(Unknown Source)
at com.m.internal.jdbc.msg.MInternalMsgEreply.deserialize(Unknown Source)
at com.m.internal.jdbc.comm.MInternalStream.readMsg(Unknown Source)
at com.m.internal.jdbc.comm.MInternalCommType4.prepareExecute(Unknown Source)
at com.m.internal.jdbc.driver.MInternalPreparedStatementImpl.executeCompleteSQL(Unknown Source)
at com.m.internal.jdbc.driver.MInternalPreparedStatementImpl.executeInternal(Unknown Source)
at com.m.internal.jdbc.driver.MInternalPreparedStatementImpl.executeQuery(Unknown Source)
at com.m.internal.jdbc.driver.MInternalPreparedStatement.executeQuery(Unknown Source)
at com.m.expimp.exporter.AbstractModeTable.setIndexPartition(AbstractModeTable.java:1213)
at com.m.expimp.exporter.v6.ModeTable6.exportTableIndex(ModeTable6.java:600)
at com.m.expimp.exporter.AbstractModeTable.exportTable(AbstractModeTable.java:175)
at com.m.expimp.exporter.AbstractModeTable.start(AbstractModeTable.java:99)
at com.m.expimp.exporter.v6.ExportInfo6.exportModeTable(ExportInfo6.java:405)
at com.m.expimp.exporter.AbstractExportInfo.exportMode(AbstractExportInfo.java:120)
at com.m.expimp.exporter.AbstractExportInfo.start(AbstractExportInfo.java:89)
at com.m.expimp.exporter.ExportMain.main(ExportMain.java:142)
JDBC-8033:Specified schema object was not found.

 

Cause

When exporting in user mode or table mode with a regular DB account, error JDBC-8033 occurs because it references dba_part_indexes and dba_idx_partitions. Since schema-dependent objects are also queried through dba_ views, if the schema does not have dba privileges, error 8033 occurs.
 
 

Solutions

Apply the patch to resolve the issue. (Applied patch: FS07_130428a_expimp)

Caution
Apply the patch through technical support provided by Tmax Tibero. 

 

 

 

Related to