Re: error while creating Table - Ora -04045

Zelga Thayer wrote:

> I am running Oracle 9.0.1 on Linux 7.2 I have created a database and
> created a tablespaces as well as a user. I want to creat a table and
> when I run
>
> CREATE TABLE adminu (
> ID NUMBER PRIMARY KEY,
> web_ID NUMBER(11))
> TABLESPACE ADMINU
> Storage
> (initial 1000k
> next 1000k
> pctincrease 10);
>
> I get the following errors.
>
> ORA 04045: Error during recompilation/revalidation of
> LBACSYS.LBAC_EVENTS
> ORA 06508: PL/SQL: could not find program unit being called
> ORA 06512: at line 2
>
> Does anyone have any idea why I am getting these errors? Any
> suggestions what I should do?
>
> I was able to run the same statement successfully in a Personal Oracle
> DB taht I am running on WIN2000. SO I know it is not the statement.
>
> Help.

I have no idea what is wrong. But I can tell you that you should not be using any value for PCTINCREASE other than zero. And you should not be declaring your primary keys as you are unless you have a profound reason to not care what names are used for the constraint and the index or where the index is built or the PCTFREE, etc.

Daniel Morgan Received on Mon Jul 29 2002 - 15:42:12 CDT