|
|
Oracle Tips by Burleson |
Create
the HTMLDB20 Tablespace
I like to
create a separate tablespace for the HTML DB objects. I recommend
this approach because otherwise the objects will likely be created in
the SYSAUX tablespace. It is especially helpful when using a Remote DBA to
create these objects on a company database. The Remote DBA may be more
willing to fulfill the request if he/she knows it can reside in its
own tablespace. The following code creates a 100MB tablespace named
HTMLDB20.
CREATE
TABLESPACE htmldb20
DATAFILE 'C:\oradata\hdb20\htmldb20_01.dbf' SIZE 102464K
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 64K
SEGMENT SPACE MANAGEMENT AUTO;
Using a uniform size of 64K will keep the total
size of the objects created to approximately 75M. This will leave
some room for growth in the 100M tablespace. The use of larger
uniform extent sizes will require the size of the htmldb tablespace to
be increased accordingly. Be careful using a larger uniform size
because there are over 600 objects and disk space requirements will
increase dramatically.
The above book excerpt is from:
Easy
HTML-DB Oracle Application Express
Create
Dynamic Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent
Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|