Re: Personal Oracle 8 on NT:create a local database

From: Henrik Staun Poulsen <hsp_at_infolog.dk>
Date: Thu, 06 Aug 1998 17:21:22 +0200
Message-ID: <35C9C9F2.458617B1@infolog.dk>

I use the following script in a init.sql file:

• run by user SYSTEM! create tablespace testuser_data datafile 'C:\ORANT\DATABASE\IFL1ORCL.ORA' SIZE 100M ONLINE;

create user testuser IDENTIFIED BY testuser DEFAULT TABLESPACE testuser_data TEMPORARY TABLESPACE temporary_data QUOTA UNLIMITED ON testuser_data;

grant create session, resource, create view TO testuser;

quit;

Best regards

Henrik Staun Poulsen Received on Thu Aug 06 1998 - 10:21:22 CDT