Re: how to create a small database in Oracle that won't eat ram

osy45 wrote:
> take the dbca and define your database.
> Store the generated batch and sql-files.
>
> run the create.bat file and let the database be build.
>
> edit the init.ora file and chose small values for db_block_buffers and
> the various pool buffers
>
> --
> Posted via http://dbforums.com

Don't! You will end up with at least:
- an INDX ts, you will never use
- TOOLS as well as USERS tablespaces, where one is sufficient.

   (only take up diskspace, though)
And probably:

- Java in the database
- interMedia
- Spatial

All you need is to edit the init.ora file (as indicated above) and trim down the batch until xxxrun and xxxrun1 remain.

Edit xxxrun1.sql to create:

- locally managed temporary tablespace
- a smaller rollback datafile
- NO index tablespace
- a smaller tools with NO users ts, or:
- a smaller users with no tools ts, or:
- small (10MB or so) users and tools tablespaces.

Make these locally managed, as well.
An example:
REM ********** TABLESPACE FOR USER ********** CREATE TABLESPACE USERS DATAFILE 'D:\oracle\oradata\demo\users01.dbf' SIZE 10M REUSE
  AUTOEXTEND ON NEXT 1280K maxsize 512M
extent management local uniform size 64k;

-- 
Regards, Frank van Bortel