Home > ISSUES > ERROR: No viable tables matched specification.

ERROR: No viable tables matched specification.

June 15, 2013

Recently I was doing some RD on add trandata and found the following error.

CASE1:-

ERROR:-

GGSCI (xyz.us.abcd.com) 8> add trandata HR.MYTESTTBL;
ERROR: No viable tables matched specification.

Cause 1 :-

GG takes “;” also in the tablename.

Resolution:-

remove “;” and re-run the same.

Eg:-

GGSCI (xyz.us.abcd.com) 9> add trandata HR.MYTESTTBL

2013-06-15 07:53:03 WARNING OGG-00869 No unique key is defined for table ‘MYTESTTBL’. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

Logging of supplemental redo data enabled for table HR.MYTESTTBL.

GGSCI (xyz.us.abcd.com) 10> info trandata HR.MYTESTTBL

Logging of supplemental redo log data is enabled for table HR.MYTESTTBL.

Columns supplementally logged for table HR.MYTESTTBL: SRNO, NAME.

GGSCI (xyz.us.abcd.com) 11>

CASE 2:-  

Again today i am doing some RD on add trandata command and found below issue and resolved in the below method.

Error:- 

GGSCI (ORA11G01.world.com) 1> dblogin userid gguser password gguser
Successfully logged into database.

GGSCI (ORA11G01.world.com) 2> add trandata scott.emp
ERROR: No viable tables matched specification.

GGSCI (ORA11G01.world.com) 3>

Root cause:-

 

gguser does not have select privs on scott schema. i tested with below command.

list tables scott.*

GGSCI (ORA11G01.world.com) 3> list tables scott.*

Found 0 tables matching list criteria.

GGSCI (ORA11G01.world.com) 4>

From DB user, i granted the SELECT ANY TABLE privs to gguser, then the issue resolved.

SYS@INDIADB>grant select any table to gguser;

Grant succeeded.

SYS@INDIADB>

Now again checked list tables command.

GGSCI (ORA11G01.world.com) 2> list tables scott.*
SCOTT.BONUS
SCOTT.DEPT
SCOTT.EMP
SCOTT.SALGRADE

Found 4 tables matching list criteria.

GGSCI (ORA11G01.world.com) 3>

Now again run add trandata.

GGSCI (ORA11G01.world.com) 5> add trandata scott.emp

Logging of supplemental redo data enabled for table SCOTT.EMP.

GGSCI (ORA11G01.world.com) 6>

 

Advertisements
Categories: ISSUES
%d bloggers like this: