////"C##AQUA_DEVELOPMENT (Source Schema)////


DROP USER "C##AQUA_DEVELOPMENT" CASCADE
GO
CREATE USER "C##AQUA_DEVELOPMENT" IDENTIFIED BY "dev"
GO
GRANT UNLIMITED TABLESPACE TO "C##AQUA_DEVELOPMENT"
GO
GRANT CONNECT TO "C##AQUA_DEVELOPMENT"
GO
GRANT CREATE SESSION TO "C##AQUA_DEVELOPMENT"
GO
GRANT ALTER ANY TABLE TO "C##AQUA_DEVELOPMENT"
GO
GRANT CREATE ANY INDEX TO "C##AQUA_DEVELOPMENT"
GO
GRANT CREATE ANY PROCEDURE TO "C##AQUA_DEVELOPMENT"
GO
CREATE TABLE "C##AQUA_DEVELOPMENT"."EMPLOYMENT_TYPE"  (
  "EMPLOYMENT_TYPE"      VARCHAR2(25 BYTE) NOT NULL,
  "EMPLOYMENT_TYPE_ID"   VARCHAR2(255 BYTE) NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_DEVELOPMENT"."EMPLOYEE_BU"  (
  "ENTITY_ID"        NUMBER NULL,
  "LOCATION"         VARCHAR2(255 BYTE) NOT NULL,
  "MANAGER"          VARCHAR2(255 BYTE) NOT NULL,
  "MFG"              VARCHAR2(255 BYTE) NOT NULL,
  "PART_ID"          NUMBER NULL,
  "PART_NAME"        VARCHAR2(255 BYTE) NULL,
  "PRODUCT_ID"       NUMBER NULL,
  "PRODUCT_IMAGE"    BFILE NULL,
  "PRODUCT_NAME"     VARCHAR2(255 BYTE) NULL,
  "RELEASE_DATE"     TIMESTAMP(6) NULL,
  "RETAILER_ID"      NUMBER NULL,
  "RETAILER_NAME"    VARCHAR2(255 BYTE) NULL
  )
GO
CREATE TABLE "C##AQUA_DEVELOPMENT"."EMPLOYEE_SALARY_TAX_DETAILS"  (
  "EMPLOYEE_NAME"    VARCHAR2(255 BYTE) NULL,
  "SALARY"           FLOAT NULL,
  "TAX"              FLOAT NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_DEVELOPMENT"."EMPLOYEE_DEPARTMENT"  (
  "AGGREGATE"        FLOAT NULL,
  "CENTER_NAME"      VARCHAR2(255 BYTE) NULL,
  "CODE"             NUMBER(15,5) NULL,
  "DATE_OF_VERIFY"   TIMESTAMP(6) NULL,
  "DATE&TIME"        TIMESTAMP(6) NULL,
  "ROLL_NO."         NUMBER(15,5) NULL,
  "SEMESTER"         VARCHAR2(255 BYTE) NULL,
  "STATUS"           VARCHAR2(255 BYTE) NULL,
  "STUDENT_NAME"     VARCHAR2(255 BYTE) NULL,
  "TOTAL"            FLOAT NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( BUFFER_POOL DEFAULT )
PARALLEL( DEGREE DEFAULT )
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_DEVELOPMENT"."EMPLOYEE_AUDIT"  (
  "ACTION"       VARCHAR2(255 BYTE) NULL,
  "EMP_NAME"     VARCHAR2(255 BYTE) NULL,
  "EMP_PASSWORD" VARCHAR2(255 BYTE) NULL,
  "EMP_USERNAME" VARCHAR2(255 BYTE) NULL,
  "UPDATE_DATE"  TIMESTAMP(6) NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
//NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_DEVELOPMENT"."EMPLOYEES"  (
  "EMPLOYEE_TRANSACTION_ID"  NUMBER(15,5) NULL
  )
STORAGE( BUFFER_POOL DEFAULT )
PARALLEL( DEGREE DEFAULT )
GO
CREATE TABLE "C##AQUA_DEVELOPMENT"."EMPLOYMENT_DESIGNATION"  (
  "EMPLOYEE_TYPE"    VARCHAR2(25 BYTE) NOT NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE OR REPLACE VIEW "C##AQUA_DEVELOPMENT"."EMPLOYEE_AUDIT_VIEW" ( "ACTION", "EMP_NAME", "EMP_PASSWORD", "EMP_USERNAME", "UPDATE_DATE" )
AS
SELECT "ACTION","EMP_NAME","EMP_PASSWORD","EMP_USERNAME","UPDATE_DATE" FROM  "C##AQUA_DEVELOPMENT"."EMPLOYEE_AUDIT"
GO
CREATE SYNONYM  "C##AQUA_DEVELOPMENT"."EMPLOYEE_AUDIT_SYNONYM"
  FOR "C##AQUA_DEVELOPMENT"."EMPLOYEE_AUDIT"
GO
CREATE OR REPLACE PACKAGE "C##AQUA_DEVELOPMENT"."EMPLOYEE_AUDIT_PACKAGE" AS
PROCEDURE addEMPLOYEE_AUDIT("ACTION_1" "EMPLOYEE_AUDIT"."action"%type);
END "EMPLOYEE_AUDIT_PACKAGE";
GO




////"C##AQUA_TEST" (Target Schema)////


DROP USER "C##AQUA_TEST" CASCADE
GO
CREATE USER "C##AQUA_TEST" IDENTIFIED BY "dev"
GO
GRANT UNLIMITED TABLESPACE TO "C##AQUA_TEST"
GO
GRANT CONNECT TO "C##AQUA_TEST"
GO
GRANT CREATE SESSION TO "C##AQUA_TEST"
GO
GRANT ALTER ANY TABLE TO "C##AQUA_TEST"
GO
GRANT CREATE ANY INDEX TO "C##AQUA_TEST"
GO
GRANT CREATE ANY PROCEDURE TO "C##AQUA_TEST"
GO
CREATE TABLE "C##AQUA_TEST"."EMPLOYMENT_TYPE"  (
  "EMPLOYMENT_TYPE_CATEGOR"      varchar2(255 BYTE)  NULL,
  "EMPLOYMENT_TYPE_IDD"  VARCHAR2(200 BYTE) NOT NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
//NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_TEST"."EMPLOYEE_BU"  (
  "ENTITY_ID"        NUMBER NULL,
  "LOCATION"         CHAR(25) NULL,
  "MANAGER"          VARCHAR2(255 BYTE) NULL,
  "MFG"              VARCHAR2(255 BYTE) NULL,
  "PART_ID"          NUMBER NULL,
  "PART_NAME"        VARCHAR2(255 BYTE) NULL,
  "PRODUCT_ID"       NUMBER(15,4) NULL,
  "PRODUCT_IMAGEE" BFILE NULL,
  "PRODUCT_NAME"     DATE NULL,
  "RETAILER_ID"      NUMBER NULL,
  "RETAILER_NAME"    VARCHAR2(25 BYTE) NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_TEST"."EMPLOYEE_SALARY_TAX_DETAILS"  (
  "EMPLOYEE_NAME"    VARCHAR2(25) NOT NULL,
  "SALARY"           NUMBER NOT NULL,
  "TAX"              FLOAT NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_TEST"."EMPLOYEE_DEPARTMENT"  (
  "AGGREGATE"        FLOAT NULL,
  "CENTER_NAME"      VARCHAR2(25 BYTE) NULL,
  "CODE"             NUMBER(10,2) NULL,
  "DATE_OF_VERIFY"   TIMESTAMP(5) NULL,
  "DATE&TIME"        TIMESTAMP(5) NULL,
  "ROLL_NO."         NUMBER(15,7) NULL,
  "SEMESTER"         VARCHAR2(25 BYTE) NULL,
  "STATUS"           VARCHAR2(25 BYTE) NULL,
  "STUDENT_NAME"     VARCHAR2(25 BYTE) NULL,
  "TOTAL"            FLOAT NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( BUFFER_POOL DEFAULT )
PARALLEL( DEGREE DEFAULT )
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_TEST"."EMPLOYEE_AUDIT"  (
  "ACTION"       VARCHAR2(25 BYTE) NOT NULL,
  "EMP_NAME"     VARCHAR2(25 BYTE) NOT NULL,
  "EMP_PASSWORD" VARCHAR2(25 BYTE) NOT NULL,
  "EMP_USERNAME" VARCHAR2(25 BYTE) NOT NULL,
  "UPDATE_DATE"  TIMESTAMP(6) NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE TABLE "C##AQUA_TEST"."EMPLOYEE_TRANSACTION_HISTORY"  (
  "EMPLOYEE_TRANSACTION_ID"  NUMBER(15,5) NULL
  )
STORAGE( BUFFER_POOL DEFAULT )
PARALLEL( DEGREE DEFAULT )
GO


CREATE TABLE "C##AQUA_TEST"."EMPLOYMENT_DESIGNATION"  (
  "EMPLOYEE_TYPE"    VARCHAR2(25 BYTE) NOT NULL
  )
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
CREATE OR REPLACE VIEW "C##AQUA_TEST"."EMPLOYEE_DEPARTMENTYET"
AS
select * from "C##AQUA_TEST"."EMPLOYEE_DEPARTMENT"
GO
CREATE OR REPLACE PACKAGE "C##AQUA_TEST"."EMPLOYEE_AUDIT_PACKAGE" AS
PROCEDURE addEmp_name("EMP_NAME_1" "EMPLOYEE_AUDIT"."Emp_name"%type);
END "EMPLOYEE_AUDIT_PACKAGE";
GO