Re: datafiles tablespace and stored procedures

Word of warning about messing about with the sql.bsq file.

1. If you want to create the PL/SQL objects in another tablespace, make sure that the tablespace is created within sql.bsq, that rollback segments are created and put on line (so that you can write to a non SYSTEM tablespace), and then create the PL/SQL objects.
2. Test the new sql.bsq file against a dummy database.
3. Unless Oracle Consulting does this, you will probably not be supported. I do know that Oracle UK consulting does this with Financial Installations, but it is still not well supported.

Good Luck,
Andrew

Jonathan Lewis wrote:

> Well, it may not be recommended by Oracle,
> but you can actually intercept sql.bsq and
> put in the pl/sql-based tables into a sensible
> tablespace.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> tlondon_at_my-dejanews.com wrote in message
> <7fq07c$t8h$1_at_nnrp1.dejanews.com>...
> >In article <7fpsk8$pno$1_at_nnrp1.dejanews.com>,
> > alexman_at_icis-corp.com wrote:
> >
> >They can only go in the system tablespace, mores the pity. with regards to
> the
> >size dba_source will show you the size of the source code the executable
> code
> >size can be computed from the sum of IDL_UB1$ IDL_CHAR$ IDL_UB2$ IDL_SB4$
> >data dictionary tables.
> >
Received on Fri Apr 23 1999 - 23:04:21 CDT