When I try to reorg a table thru OEM, I get a "Operating system resource
shortage" message everytime (can be different tablespace/tables - same
server). When I execute the stmts in SQL*Plus, they work fine.

Any ideas?

- Anthony




start of main script
Executing script in direction: Proceed and Clean Up
Executing as user SYS

-- Script Generation for PLAN$_157
-- Plan was last modified: 30-Jun-2005
-- Target destination db : prod.sptora01
-- Generation started at: 30-Jun-2005
-- Generation finished at: 30-Jun-2005
DROP INDEX "BO_PROD"."PKX_DOCUMENTS"
-- Renaming the table for the purpose of recovery. Cleanup will remove
the old table.
CONNECT AS: BO_PROD
RENAME "OBJ_X_DOCUMENTS" TO "OBJ_X_DOCUMENTS$$OCMrecovery"
CREATE TABLE "BO_PROD"."OBJ_X_DOCUMENTS" ("X_DOC_N_ID" NUMBER(10) NOT
NULL, "X_DOC_N_BLOCKID" NUMBER(10) NOT NULL, "X_DOC_B_CONTENT" LONG RAW
NOT NULL) TABLESPACE "BOTBL_PROD" PCTFREE 10 PCTUSED 40 INITRANS 1
MAXTRANS 255 STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) LOGGING
COMMENT ON TABLE "BO_PROD"."OBJ_X_DOCUMENTS" IS 'Document storage table'
-- Moving table data that contains a long column requires a PL/SQL
procedure.
Copying data using:
declare
cursor c1 IS
SELECT "X_DOC_N_ID", "X_DOC_N_BLOCKID", "X_DOC_B_CONTENT"
FROM "BO_PROD"."OBJ_X_DOCUMENTS$$OCMrecovery" ;
BEGIN
FOR c1rec in c1 loop
INSERT INTO "BO_PROD"."OBJ_X_DOCUMENTS" ( "X_DOC_N_ID",
"X_DOC_N_BLOCKID", "X_DOC_B_CONTENT" ) VALUES
(c1rec."X_DOC_N_ID",c1rec."X_DOC_N_BLOCKID",c1rec."X_DOC_B_CONTENT");
END loop;
commit;
END;

CREATE UNIQUE INDEX "BO_PROD"."PKX_DOCUMENTS" ON
"BO_PROD"."OBJ_X_DOCUMENTS" ("X_DOC_N_ID", "X_DOC_N_BLOCKID")
TABLESPACE "BOTBL_PROD" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (
INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
FREELISTS 1 FREELIST GROUPS 1) LOGGING ONLINE
Starting cleanup of recovery tables...
DROP TABLE "BO_PROD"."OBJ_X_DOCUMENTS$$OCMrecovery"
Completed cleanup of recovery tables.


Operating system resource shortage.

Oracle LazyDBA home page