MySQL Forums
Forum List  »  Oracle

How do I calculate my Storage Clause values?
Posted by: Naveen Thinarthan
Date: August 05, 2021 04:20AM

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 )

);

Options: ReplyQuote


Subject
Views
Written By
Posted
How do I calculate my Storage Clause values?
475
August 05, 2021 04:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.