Solved

dbms.tts

Posted on 2006-06-29
4
1,027 Views
Last Modified: 2012-06-22
Hi
I am getting this error when I am trying to run this---

SQL> EXECUTE SYS.DBMS.TTS_TRANSPORT_SET_CHECK('TS_01',TRUE);
BEGIN SYS.DBMS.TTS_TRANSPORT_SET_CHECK('TS_01',TRUE); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.

It was used to run successfully before.

Any help would be appreciated.

thanks in advance.

0
Comment
Question by:Smruti1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 17011170
It should be:

sys.dbms_tts.transport_set_check('TS_01', TRUE);

You have some of the "."s and "_"s mixed up.
0
 

Author Comment

by:Smruti1
ID: 17011223
Thanks johnsone.

You are right . It was my mistake.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question