Home » RDBMS Server » Server Administration » dba_views
dba_views [message #240089] Thu, 24 May 2007 02:07 Go to next message
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..
Re: dba_views [message #240100 is a reply to message #240089] Thu, 24 May 2007 02:31 Go to previous messageGo to next message
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.

Re: dba_views [message #240105 is a reply to message #240089] Thu, 24 May 2007 02:37 Go to previous messageGo to next message
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
Re: dba_views [message #240123 is a reply to message #240089] Thu, 24 May 2007 03:30 Go to previous messageGo to next message
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
Re: dba_views [message #240127 is a reply to message #240123] Thu, 24 May 2007 03:39 Go to previous messageGo to next message
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
Re: dba_views [message #240134 is a reply to message #240127] Thu, 24 May 2007 04:08 Go to previous messageGo to next message
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
Re: dba_views [message #240203 is a reply to message #240100] Thu, 24 May 2007 06:24 Go to previous messageGo to next message
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
Re: dba_views [message #240254 is a reply to message #240089] Thu, 24 May 2007 08:22 Go to previous messageGo to next message
letyrolien
Messages: 6
Registered: March 2007
Junior Member
Have you tried using the owner of the views ?

owner.view
Re: dba_views [message #240260 is a reply to message #240254] Thu, 24 May 2007 08:39 Go to previous messageGo to next message
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
Re: dba_views [message #240382 is a reply to message #240260] Thu, 24 May 2007 13:01 Go to previous message
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
Previous Topic: Microsoft ODBC for Oracle Provider not found
Next Topic: sqlplus
Goto Forum:
  


Current Time: Fri Dec 06 02:30:40 CST 2024