Sample SQL

The following SQL commands are not run by the installation but show an example of what a database administrator needs to do to create the tablespaces. Database administrators must set up the tablespaces before installing the Central Designer software.

CREATE TABLESPACE designer

LOGGING

DATAFILE 'D:\Oracle\oradata\dev1\DESIGNER.ora' SIZE 400M

AUTOEXTEND ON NEXT 1M;

ALTER SYSTEM SET db_16k_cache_size = 80M;

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;