Add Trandata : ERROR: No viable tables matched specification.

ERROR:-

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

Cause:-

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>