|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Need help on fragmentation
Hi all,
I have a problem. I am studying primary fragmentation and derived fragma and I am creating views for the primary horizontal fragmentation of the Department table and for the derived fragmentation of table Employee. and demonstrating reconstruction of the tables. This is my table and view for department and employee: CREATE TABLE DEPARTMENT (deptCode CHAR(03) PRIMARY KEY NOT NULL, DeptName VarCHAR2(20) NOT NULL, Location VarCHAR2(20), deptType VarCHAR2(20) NOT NULL); CREATE TABLE EMPLOYEE (ID smallint PRIMARY KEY NOT NULL, EMPLNAME VarCHAR2(20) NOT NULL, EMPLTYPE VarCHAR2(20), DEPTCODE CHAR(03) NOT NULL, TITLECODE CHAR(02) NOT NULL, CONSTRAINT emp_FK1 FOREIGN KEY (DEPTCODE) REFERENCES DEPARTMENT (DEPTCODE), CONSTRAINT emp_FK2 FOREIGN KEY (titleCode) REFERENCES TITLE(titleCode)); CREATE VIEW Department AS SELECT deptCode, deptName,deptLoc, deptType FROM Department WHERE deptno = 10 WITH CHECK OPTION CONSTRAINT insert_Dept; CREATE VIEW Employee AS SELECT EMPLNAME, EMPLTYPE FROM Employee WHERE deptno = 10 WITH CHECK OPTION CONSTRAINT insert_Employee; my problem is with the fragmentation. I dont know how the fragmentation is supposed to be written. Could anyone help me out with this by showing me an example of this. Thanks |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Need help on fragmentation |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|