sql.bsq for Oracle 8i vs Oracle 7.3.4 
Author Message
 sql.bsq for Oracle 8i vs Oracle 7.3.4

Currently using Oracle 7.3.4 on Sun Solaris 2.6.

I will be installing Oracle 8i soon and I was wondering if there
is a $ORACLE_HOME/dbs/sql.bsq file for this version, or if in
version 8 there is a complete overhaul of how a database is
created?

Usually I have edited the sql.bsq file to have larger initial and
next extents for some of the tables and I was wondering if I can
do this for Oracle 8i or is this no longer necessary or even
possible.

The sql.bsq file didn't change much from Oracle 7.0 to Oracle 7.3.4.
I was wondering if someone who has migrated to Oracle 8i from
Oracle 7, could tell me if the sql.bsq file looks similar or even
if it exists.

Thanks!
Debbie Yoshihara
Department of Biostatistics and Medical Informatics
UW Madison



Mon, 20 Aug 2001 03:00:00 GMT
 sql.bsq for Oracle 8i vs Oracle 7.3.4

Hi Debbie:

    I haven't done 8i (yet) but I've done 8.05 and that has a greatly
expanded sql.bsq in the ORANT8\RDBMS80\ADMIN
directory.

Van

Quote:

>Currently using Oracle 7.3.4 on Sun Solaris 2.6.

>I will be installing Oracle 8i soon and I was wondering if there
>is a $ORACLE_HOME/dbs/sql.bsq file for this version, or if in
>version 8 there is a complete overhaul of how a database is
>created?

>Usually I have edited the sql.bsq file to have larger initial and
>next extents for some of the tables and I was wondering if I can
>do this for Oracle 8i or is this no longer necessary or even
>possible.

>The sql.bsq file didn't change much from Oracle 7.0 to Oracle 7.3.4.
>I was wondering if someone who has migrated to Oracle 8i from
>Oracle 7, could tell me if the sql.bsq file looks similar or even
>if it exists.

>Thanks!
>Debbie Yoshihara
>Department of Biostatistics and Medical Informatics
>UW Madison



Mon, 20 Aug 2001 03:00:00 GMT
 sql.bsq for Oracle 8i vs Oracle 7.3.4
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.

Quote:

>Currently using Oracle 7.3.4 on Sun Solaris 2.6.

>I will be installing Oracle 8i soon and I was wondering if there
>is a $ORACLE_HOME/dbs/sql.bsq file for this version, or if in
>version 8 there is a complete overhaul of how a database is
>created?

>Usually I have edited the sql.bsq file to have larger initial and
>next extents for some of the tables and I was wondering if I can
>do this for Oracle 8i or is this no longer necessary or even
>possible.

>The sql.bsq file didn't change much from Oracle 7.0 to Oracle 7.3.4.
>I was wondering if someone who has migrated to Oracle 8i from
>Oracle 7, could tell me if the sql.bsq file looks similar or even
>if it exists.

>Thanks!
>Debbie Yoshihara
>Department of Biostatistics and Medical Informatics
>UW Madison



Tue, 21 Aug 2001 03:00:00 GMT
 sql.bsq for Oracle 8i vs Oracle 7.3.4

(if that email address didn't require changing)

sql.bsq is still there.  all of the mods to it are in the header as a big
comment for you to review.

Quote:

>Currently using Oracle 7.3.4 on Sun Solaris 2.6.

>I will be installing Oracle 8i soon and I was wondering if there
>is a $ORACLE_HOME/dbs/sql.bsq file for this version, or if in
>version 8 there is a complete overhaul of how a database is
>created?

>Usually I have edited the sql.bsq file to have larger initial and
>next extents for some of the tables and I was wondering if I can
>do this for Oracle 8i or is this no longer necessary or even
>possible.

>The sql.bsq file didn't change much from Oracle 7.0 to Oracle 7.3.4.
>I was wondering if someone who has migrated to Oracle 8i from
>Oracle 7, could tell me if the sql.bsq file looks similar or even
>if it exists.

>Thanks!
>Debbie Yoshihara
>Department of Biostatistics and Medical Informatics
>UW Madison

Thomas Kyte

Oracle Service Industries
Reston, VA   USA

--
http://govt.us.oracle.com/    -- downloadable utilities

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



Tue, 21 Aug 2001 03:00:00 GMT
 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



Tue, 21 Aug 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Oracle 8i Standard vs. Oracle 8i Enterprise edition

2. HELP: Oracle 8i vs 9i vs MS SQL 2000

3. Oracle 8i MTS (Oracle 8i for Windows NT - Oracle Services for Microsoft Transaction Server)

4. Oracle 8i MTS (Oracle 8i for Windows NT - Oracle Services for Microsoft Transaction Server)

5. Oracle 9i listener vs Oracle 8i extproc

6. Oracle 8 vs. Oracle 8i

7. oracle 8i vs oracle applicaiton server

8. Oracle 8 vs. Oracle 8i

9. Project Cascade vs Oracle 8i vs Samba?

10. SQL Server 7 vs Oracle 8i

11. MS SQL vs. Oracle 8i

12. SQL Server 7/2000 vs Oracle 8i


 
Powered by phpBB® Forum Software