Database DataWarehousing (MOSC)

MOSC Banner

dbms_tts cannot work

edited Sep 8, 2015 10:07AM in Database DataWarehousing (MOSC) 11 commentsAnswered

I have a problem when running stored procedure on Oracle 11g after being upgraded from 10gr2:

SQL> begin

sys.dbms_tts.transport_set_check

('USERS', incl_constraints=>TRUE, full_check=>FALSE);

end;

/  2    3    4    5

begin

*

ERROR at line 1:

ORA-01403: no data found

ORA-06512: at "SYS.DBMS_TTS", line 790

ORA-06512: at "SYS.DBMS_TTS", line 888

ORA-06512: at line 2

It seems that dbms_tts is valid, but anyway I have recompiled it, but still getting the same error.

There is also a another smaller database instance on that server, using the same software where dbms_tts is working fine.

Any ideas?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center