I'm trying to use DBMS_REDEFINITION to move a very large non-partitioned table into being partitioned. I set up a case to learn more about this package. But I keep running up into the error below.
Here's the privilegs assigned to me: Do I need something else? What am I missing?
<pre>
Adm
Granted Opt Dfl
----------------------------------------------------------------- --- ---
CONNECT NO YES
RESOURCE NO YES
SELECT_CATALOG_ROLE NO YES
ALTER ANY TABLE NO
CREATE ANY INDEX NO
CREATE ANY TABLE NO
CREATE ANY TRIGGER NO
DROP ANY TABLE NO
SELECT ANY TABLE NO
UNLIMITED TABLESPACE NO
-- ---------------------------------------------------------------------------
DROP TABLE t;
DROP TABLE t_interim;
CREATE TABLE t
NOLOGGING
AS
SELECT
*
FROM
all_objects;
CREATE INDEX ix_1
ON t ( owner )
COMPUTE STATISTICS ;
CREATE INDEX ix_2
ON t ( object_name )
COMPUTE STATISTICS;
BEGIN
DBMS_REDEFINITION.CAN_REDEF_TABLE ( user,
'T',
2 );
END;
/
DBMS_REDEFINITION.CAN_REDEF_TABLE ( user,
*
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00201: identifier 'DBMS_REDEFINITION' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored
</pre>