OraFAQ Forum: Server Administration » dba

Home » RDBMS Server » Server Administration » dba_views

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dba_views [message #240089]

Thu, 24 May 2007 02:07

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

hi, i connected to sys as sysdba, and after giving the query desc dba_tablespaces or dba_data_files, it is showing an error..

error:sp2-0749:cannot resolve circular path of synonym "dba_tablespaces"

but when iam giving desc dba_users; its giving the list, can anyone solve my query?

thanks in advance..

Report message to a moderator

Re: dba_views [message #240100 is a reply to message #240089]

Thu, 24 May 2007 02:31

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Quote:

SP2-0749 Cannot resolve circular path of synonym synonym_name

Cause: An attempt was made to use a synonym to point to an object that no longer exists where the synonym had the same name as the base object, or an attempt was made to use a synonym that has a circular path that points back to itself.

Action: Make sure that the last synonym in the synonym path points to an object that exists, and that it doesn't point back to itself.

Report message to a moderator

Re: dba_views [message #240105 is a reply to message #240089]

Thu, 24 May 2007 02:37

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Can you post exact CUT & PASTE your sql statement
and sure are you connect with "SYS AS SYSDBA" user ?
Regards
Taj

Report message to a moderator

Re: dba_views [message #240123 is a reply to message #240089]

Thu, 24 May 2007 03:30

moiznaz
Messages: 4
Registered: May 2007
Location: Dubai

Junior Member

Dear Taj

Connect youself as a sysdba by given this command

sql> connect system/manager@---- your alais name (like orion.world) etc the press enter. Then give command

sql> SHO USER

you will c there

sql> USER IS SYSTEM

then u type desc dba_tablespaces ... u will not get any error mesg.

Regards
Moiz Ali

Report message to a moderator

Re: dba_views [message #240127 is a reply to message #240123]

Thu, 24 May 2007 03:39

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1. Are you understand what is problem ?
2. You know who is OP ?
3. Please don't use IMSPEAK
4. What is relation between YOUR REPLY WITH ACTUAL QUESTION ?

Regards
Taj

Report message to a moderator

Re: dba_views [message #240134 is a reply to message #240127]

Thu, 24 May 2007 04:08

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

thanks for ur reply taj, iam sure i connected to sys as sysdba

1) startup
2)show user
3)user is sys
4)desc dba_tablespaces or desc dba_data_files
for only these two queries it is showing error except these two all dba_views are working,

regards
kiran

Report message to a moderator

Re: dba_views [message #240203 is a reply to message #240100]

Thu, 24 May 2007 06:24

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

hanks for ur reply, can u tell me how hat the last synonym in the synonym path points to an object that exists, and that it doesn't point back to itself.

thanks

Report message to a moderator

Re: dba_views [message #240254 is a reply to message #240089]

Thu, 24 May 2007 08:22

letyrolien
Messages: 6
Registered: March 2007

Junior Member

Have you tried using the owner of the views ?

owner.view

Report message to a moderator

Re: dba_views [message #240260 is a reply to message #240254]

Thu, 24 May 2007 08:39

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

You probably have to execute catalog.sql
$ORACLE_HOME/rdbms/admin as sys
which will recreate all dba synonyms

Report message to a moderator

Re: dba_views [message #240382 is a reply to message #240260]

Thu, 24 May 2007 13:01

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

i did not try by using owner.view i will try and i will run once again catalog.sql

thank a lot

Report message to a moderator

Previous Topic:	Microsoft ODBC for Oracle Provider not found
Next Topic:	sqlplus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:19:20 CDT 2024