 |
|
Oracle Tips by Burleson |
Create
the HTML DB Database Objects
After the tablespace is created, the HTML DB
objects will have to be created. During the installation of HTML DB,
there are three schemas
created. The names of the schemas
and brief descriptions of their purposes are provided in Table 2.1
below:
|
SCHEMA |
DESCRIPTION |
|
FLOWS_020000 |
This is the owner of all the tables, views,
and packages installed for HTML DB. The exception is the table
installed in the FLOWS_FILES schema for the storage of files in
the database. The FLOWS_020000 account is locked at the end of
the installation and cannot be used unless it is first unlocked. |
|
FLOWS_FILES |
This schema is created to hold uploaded
files. When a file, such as a script, cascading style sheet,
document, etc., is uploaded into the HTML DB workspace this is
where it is stored. This account is locked at the end of the
installation and cannot be used unless it is unlocked first. |
|
HTMLDB_PUBLIC_USER |
This is the schema that is used by Oracle
HTTP Server to log into the HTML DB database. It provides HTML DB
functionality by using the objects in the other two schemas. |
Table 2.1:
HTML DB schemas and their descriptions
All the necessary HTML DB objects are installed by
running the following command in SQLPlus. A
description of the command line parameters is provided in Table 2.2.
sqlplus
"sys/htmldb@hdb20 as sysRemote DBA" @htmldbins hdbpwd htmldb20 htmldb20
temp /i/ hdb20
|
COMMAND LINE PARAMETER |
DESCRIPTION |
|
sqlplus “sys/syspwd@hdb20 as sysRemote DBA” |
starts sqlplus and logs in as sys |
|
@htmldbins |
The installation script for HTML DB version
2.0 |
|
hdbpwd |
The password to be given to the schema owners
of the HTML DB objects – FLOWS_020000. |
|
htmldb20 |
Default tablespace given to the FLOWS_020000
schema owner of the HTML DB objects. |
|
htmldb20 |
Default tablespace given to the FLOWS_FILES
schema owner. The table created in this schema is where any
uploaded files are stored. This could be a separate tablespace,
but it is easier to just have one. |
|
temp |
The name of the default temporary tablespace
to be given to all schemas
created during installation. |
|
/i/ |
The name of the virtual directory to be used
for images being rendered in HTML DB. The use of this value is
recommended |
|
hdb20 |
This is the connect string for the database
where HTML DB is being installed. |
Table 2.2:
HTML DB command line parameters and their descriptions
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
|
