Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
Library | Service | Contents | Index

Using XSQL Servlet, 13 of 24

## Setting Up the demo/ Data

To set up the demo data do the following:

1. Change directory to the .\xsql\demo directory on your machine.

2. In this directory, run SQLPLUS. Connect to your database as CTXSYS/CTXSYS (the schema owner for Intermedia Text packages) and issue the command

       GRANT EXECUTE ON CTX_DDL TO SCOTT;

3. Connect to your database as SYSTEM/MANAGER and issue the command:

       GRANT QUERY REWRITE TO SCOTT;

   This allows SCOTT to create a functional index that one of the demos uses to perform case-insensitive queries on descriptions of airports.

4. Connect to your database as SCOTT/TIGER.

5. Run the script `install.sql` in the ./xsql/demo directory. This script runs all SQL scripts for all the demos.

       install.sql
       @@insclaim/insclaim.sql
       @@document/docdemo.sql
       @@classerr/invalidclasses.sql
       @@airport/airport.sql
       @@insertxml/newsstory.sql
       @@empdept/empdeptobjs.sql

6. Change directory to doyouxml/ subdirectory, and run the following:

       imp scott/tiger file=doyouxml.dmp

   to import sample data for the "Do You XML? Site" demo.

7. To experience the Scalable Vector Graphics (SVG) demonstration, install an SVG plug-in into your browser, such as Adobe SVG Plug-in.

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index