How do I calculate my Storage Clause values?

[Naveen Thinarthan]

Hey, can someone please tell me how do i calculate the values for my storage the one i have here doesn't work and throws a error. Thank you very much.

Create table MOVIE

(

MOVIE_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_NAME Varchar2(55),

MOVIE_RELEASE_DATE date,

MOVIE_RATING Varchar2(5) DEFAULT 'NR',

CHECK (MOVIE_RATING = 'G'OR MOVIE_RATING = 'PG' OR MOVIE_RATING = 'PG-13' OR MOVIE_RATING = 'R' OR MOVIE_RATING = 'NC'),

TOTAL_SALES number(10),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);



CREATE TABLE Producer(

Pro_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL UNIQUE,

Pro_fname Varchar2(30),

Pro_lname Varchar2(30),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);



CREATE TABLE Theater(

Tht_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

Tht_name Varchar2(55),

Tht_address Varchar2(350),

Tickets_sold NUMBER(19),

CHECK (Tickets_sold >=0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);



CREATE TABLE Ticket_Price(

Ticket_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

Tht_ID number(10) NOT NULL UNIQUE,

Ticket_Price number(10) ,

CHECK (Ticket_Price >=0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

FOREIGN KEY (Tht_ID) REFERENCES Theater(Tht_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);





CREATE TABLE Main_Actor(

Actor_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

First_Name Varchar2(20),

Last_Name Varchar2(20),

Payment_amount number(10),

CHECK (Payment_amount >0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);



CREATE TABLE Supporting_Actor(

sActor_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

First_Name Varchar2(20),

Last_Name Varchar2(20),

Payment_amount number(10),

CHECK (Payment_amount >0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);