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 Oracle 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;