Re: Possibly a stupid one : Change SOURCE$ definition

There should be no problem in changing the next extent of the table ( alter table source$ storage (next 200k) ). However, don't try to drop or recreate this table. This is a datadictionary table, and shouldn't be tampered with. The only other supported way is to modify sql.bsq (the dictionary creation script) and change the generic initial extent. sql.bsq may not exist though in all versions anymore.

Hth,

Sybrand Bakker, Oracle DBA

Renauld Chapellier wrote:

> Dear All,
>
> I have installed Oracle Applications. It is using a bit of PL/SQL.
> So, SOURCE$ is overextented.
>
> I guess I could modified the storage parameters before installing,
> but I more interrested in where this table has been initialy created.
>
> Many chance that it is created through wrapped PL/SQL, we have
> no access to. But I give a try.
>
> Renauld
> rc_at_aia.com
Received on Mon Nov 09 1998 - 16:23:56 CST