Oracle, sql.bsq for Oracle 8i vs Oracle 7.3.4

sql.bsq for Oracle 8i vs Oracle 7.3.4

Author	Message
Debbie Yoshihar #1 / 5	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

Van Messne #2 / 5	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

Kristiaan J. Kol #3 / 5	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

Thomas Ky #4 / 5	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

Jurij Mod #5 / 5	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

Page 1 of 1

[ 5 post ]