
sql.bsq for Oracle 8i vs Oracle 7.3.4
On Fri, 5 Mar 1999 13:35:24 -0800, "Kristiaan J. Kolk"
Quote:
>read the readme that comes with Oracle8 or Oracle8i and it tells you that
>can't change the file ..... (even though it seems to work).
>Anjo.
In "Oracle8 Tuning" manual (both in 8.0 and 8i-beta versions) there is
a mentioning what you may and what you must not manualy change in the
SQL.BSQ. Here is a quote from there:
<begin quote>
Modifying the SQL.BSQ File
The SQL.BSQ file is run when you issue the CREATE DATABASE statement.
This file contains the actual table definitions that make up the
Oracle Server. The views that you use as a DBA are based on these
tables. Oracle Corporation recommends that users strictly limit their
modifications to SQL.BSQ.
- If necessary, you can increase the value of the following storage
parameters: INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE,
FREELISTS, FREELIST GROUPS, and OPTIMAL.
- With the exception of PCTINCREASE, you should not decrease the
setting of a storage parameter to a value below the default. (If the
value of MAXEXTENTS is large, you can make PCTINCREASE smallor even
zero.)
- No other changes to SQL.BSQ are supported. In particular, you should
not add, drop, or rename a column.
<end quote>
HTH,
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer