Home » SQL & PL/SQL » SQL & PL/SQL » dimensions
dimensions [message #227976] Fri, 30 March 2007 09:06 Go to next message
chaits85
Messages: 2
Registered: March 2007
Junior Member
I want to create a dimension hierarchy on a table 'time' but am unable to create it. I'm putting the structure of the table as well as the message oracle gives when i try to create the hierarchy. pls help.

Structure of table 'time' :

create table time
(timeid char(4) primary key,
day char(3),
week number,
month number,
quarter number,
year number
);

Dimension:

SQL> CREATE DIMENSION timedim
2 LEVEL DAY IS (time.day)
3 LEVEL WEEK IS (time.week)
4 LEVEL MONTH IS (time.month)
5 LEVEL QUARTER IS (time.quarter)
6 LEVEL YEAR IS (time.year)
7 HIERARCHY TIME_ROLLUP
8 (
9 day CHILD OF
10 week CHILD OF
11 month CHILD OF
12 quarter CHILD OF
13 year
14 )
15 /
CREATE DIMENSION timedim
*
ERROR at line 1:
ORA-04044: procedure, function, package, or type is not allowed here
Re: dimensions [message #227977 is a reply to message #227976] Fri, 30 March 2007 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1393603663358
Re: dimensions [message #228044 is a reply to message #227976] Fri, 30 March 2007 23:31 Go to previous message
chaits85
Messages: 2
Registered: March 2007
Junior Member
Thanks for the link bt i still dont understand hw to get rid of tht error and create the dimension. I'm new to Oracle. Could u pls explain?
Previous Topic: What is the purpose of this collection type ??
Next Topic: please help with statistics!
Goto Forum:
  


Current Time: Wed Dec 07 04:50:23 CST 2016

Total time taken to generate the page: 0.14455 seconds