Sunday, November 16, 2008

Oracle Schema Query for creating Schemas for Hyperion Installation

Hi,

Here is the query:

create user HSS identified by password;

grant dba to HSS;

create tablespace HSS
datafile 'D:\Oracle\hyperionfiles\HSS.dbf'
size 30M
Autoextend on
Extent Management local

/

alter user hyptt default tablespace HSS;

No comments: