Not able to gather Statistics of neither schema nor table [message #515745] |
Wed, 13 July 2011 03:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/151736.jpg) |
dkdms2124
Messages: 369 Registered: April 2010 Location: INDIA
|
Senior Member |
![d.sharma77](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi All,
I am connect to remote database with a user named 'TEST', this user has dba privileges. I am not able to gather the statistics of neither test schema nor for any table that exists in this schema.
Please find below the screenshot for the errors:
SQL> EXEC dbms_stats.gather_schema_stats('TEST', cascade=>TRUE);
BEGIN dbms_stats.gather_schema_stats('TEST', cascade=>TRUE); END;
*
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13556
ORA-06512: at "SYS.DBMS_STATS", line 13634
ORA-06512: at "SYS.DBMS_STATS", line 13593
ORA-06512: at line 1
SQL> EXEC dbms_stats.gather_TABLE_stats(OWNNAME=>'TEST',TABNAME=>'BUG341');
BEGIN dbms_stats.gather_TABLE_stats(OWNNAME=>'TEST',TABNAME=>'BUG341'); END;
*
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_STATS", line 13056
ORA-06512: at "SYS.DBMS_STATS", line 13076
ORA-06512: at line 1
Any reason why I am not able to do so and getting these errors.
Thanks & Regards
Deepak
|
|
|
|
Re: Not able to gather Statistics of neither schema nor table [message #515796 is a reply to message #515755] |
Wed, 13 July 2011 05:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/151736.jpg) |
dkdms2124
Messages: 369 Registered: April 2010 Location: INDIA
|
Senior Member |
![d.sharma77](/forum/theme/orafaq/images/yahoo.png)
|
|
below is the result for "show user" and session details.
SQL> /
SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS
---------------- ---------- ---------- ---------- ---------------- ---------- ------------------------------ ---------- ---------- ---------------- ----------------
00000000A13B78A8 305 7805 130620 000000009E29E910 596 TEST 3 2147483644 ACTIVE
00000000A13C2EA0 323 10689 130634 00000000A12A96C0 596 TEST 0 2147483644 INACTIVE
SQL> EXEC dbms_stats.gather_TABLE_stats(OWNNAME=>'TEST',TABNAME=>'BUG341');
BEGIN dbms_stats.gather_TABLE_stats(OWNNAME=>'TEST',TABNAME=>'BUG341'); END;
*
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_STATS", line 13056
ORA-06512: at "SYS.DBMS_STATS", line 13076
ORA-06512: at line 1
SQL> EXEC dbms_stats.gather_schema_stats('TEST', cascade=>TRUE);
BEGIN dbms_stats.gather_schema_stats('TEST', cascade=>TRUE); END;
*
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13556
ORA-06512: at "SYS.DBMS_STATS", line 13634
ORA-06512: at "SYS.DBMS_STATS", line 13593
ORA-06512: at line 1
SQL> show user
USER is "TEST"
SQL>
Thanks
Deepak
|
|
|
|
Re: Not able to gather Statistics of neither schema nor table [message #515818 is a reply to message #515796] |
Wed, 13 July 2011 08:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
dsharma wrote on Wed, 13 July 2011 06:06below is the result for "show user" and session details.
SQL> /
SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS
---------------- ---------- ---------- ---------- ---------------- ---------- ------------------------------ ---------- ---------- ---------------- ----------------
00000000A13B78A8 305 7805 130620 000000009E29E910 596 TEST 3 2147483644 ACTIVE
00000000A13C2EA0 323 10689 130634 00000000A12A96C0 596 TEST 0 2147483644 INACTIVE
No it is not. Please show your COMPLETE SESSION, including your connect string. If you do not know what this means, please ask.
|
|
|
|
Re: Not able to gather Statistics of neither schema nor table [message #515826 is a reply to message #515821] |
Wed, 13 July 2011 08:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Here is an example of a short session:
SQL> connect scott/tiger@orcltest
Connected.
SQL> show user
USER is "SCOTT"
SQL>
Then you can show any additional code you executed, like your EXEC command. Or if you want to even show the sqlplus command, you can do that too. I was already connected to sql*plus, so I just showed the connect.
|
|
|
|
|
|
|
|
|
|
|
Re: Not able to gather Statistics of neither schema nor table [message #515905 is a reply to message #515895] |
Thu, 14 July 2011 02:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/151736.jpg) |
dkdms2124
Messages: 369 Registered: April 2010 Location: INDIA
|
Senior Member |
![d.sharma77](/forum/theme/orafaq/images/yahoo.png)
|
|
If its a bug then why I am getting two different errors.
SQL> EXEC dbms_stats.gather_schema_stats('TEST', cascade=>TRUE);
BEGIN dbms_stats.gather_schema_stats('TEST', cascade=>TRUE); END;
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13556
ORA-06512: at "SYS.DBMS_STATS", line 13634
ORA-06512: at "SYS.DBMS_STATS", line 13593
ORA-06512: at line 1
SQL> EXEC dbms_stats.gather_schema_stats('TEST', cascade=>TRUE);
BEGIN dbms_stats.gather_schema_stats('TEST', cascade=>TRUE); END;
*
ERROR at line 1:
ORA-44004: invalid qualified SQL name
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13556
ORA-06512: at "SYS.DBMS_STATS", line 13634
ORA-06512: at "SYS.DBMS_STATS", line 13593
ORA-06512: at line 1
Regards
Deepak
|
|
|
Re: Not able to gather Statistics of neither schema nor table [message #515906 is a reply to message #515877] |
Thu, 14 July 2011 02:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Sir, Since it's the client database I do not know the password for the sys user. They have given me a user "scott1" with dba privileges.
So you can't make my test, ask the local DBA to do it and report you the (complete) result.
Anyway (it seems) the problem is not in your side but in database one, and so the local DBA must do something, at least open a SR.
Regards
Michel
[Updated on: Thu, 14 July 2011 02:53] Report message to a moderator
|
|
|
|