Re: datafiles tablespace and stored procedures

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 26 Apr 1999 09:10:00 -0700
Message-ID: <37248FD8.D673238B@us.oracle.com>

Andrew

Support for the change you're discussing seems to vary from release to release. I've never been able to get a concrete, across all versions answer to this. To check for your release, have a look at the sql.bsq file itself. Sometimes, it has a line in it saying that the storage parameters (and only those, obviously nothing definition wise) can be changed for all items above or below this line (I can't remember which one). Otherwise, it's probably safest to assume it's not supported.

HTH. Pete

Andrew Babb wrote:

> 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.
> > >

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Apr 26 1999 - 11:10:00 CDT