Re: freelists and dba_free_space

From: Ben <balvey_at_comcast.net>
Date: 15 Feb 2006 11:28:59 -0800
Message-ID: <1140031739.278839.264300@g47g2000cwa.googlegroups.com>

I just tried the GATHER STALE option and got an error.

---

SQL> exec DBMS_STATS.GATHER_SCHEMA_STATS ('TRDTA', 'GATHER STALE'); BEGIN DBMS_STATS.GATHER_SCHEMA_STATS ('TRDTA', 'GATHER STALE'); END;
*

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1

---

Do you have to put place holders for the parameters that you don't want to pass in?

With the dbms_space procedure. It is created under the SYS owner and resides in SYS's schema. All of my production tables are in a different schema, so when I run the procedure it tells me that the tables don't exist. I tried granting EXECUTE ANY PROCEDURE to the schema owner and logging on as that owner to run, but then encountered more errors. How is this supposed to be ran? Received on Wed Feb 15 2006 - 13:28:59 CST