I have just finished installing Oracle 10g Enterprise Edition (10.2.0.3) and would like to run the Tablespace creation scripts that were provided with the OTM install.
I have logged into SQLPLUS as SYSTEM and am within the Script8 directory. I am able to start off with the create_gc3_tablespaces script and answer all the prompted questions but when I tell it to create the tablespaces now, it immediately gives me these errors:
================================================== ====
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_partition_db('n'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_dbtype('n'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_auto_extend('y'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_execute('y'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.create_all_ts('D:\oracle\oradata ', '1024000K','2048000K'
); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
================================================== ====
I am definitely not a DBA and I see the different sql script files the original create_gc3_tablespaces script calls on within the same directory.
Can somebody give me some sugestions? Just to note, none of the scripts in this Script8 directory have been modified in any way.
Thanks
I have logged into SQLPLUS as SYSTEM and am within the Script8 directory. I am able to start off with the create_gc3_tablespaces script and answer all the prompted questions but when I tell it to create the tablespaces now, it immediately gives me these errors:
================================================== ====
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_partition_db('n'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_dbtype('n'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_auto_extend('y'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.set_execute('y'); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
BEGIN create_tablespace.create_all_ts('D:\oracle\oradata ', '1024000K','2048000K'
); END;
*
ERROR at line 1:
ORA-04063: package body "SYSTEM.CREATE_TABLESPACE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.CREATE_TABLESPACE"
ORA-06512: at line 1
================================================== ====
I am definitely not a DBA and I see the different sql script files the original create_gc3_tablespaces script calls on within the same directory.
Can somebody give me some sugestions? Just to note, none of the scripts in this Script8 directory have been modified in any way.
Thanks
Comment