LOC_DEPTO

--------------------------------------------------------
--  Arquivo criado - Terça-feira-Fevereiro-10-2015
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table LOC_DEPTO
--------------------------------------------------------

  CREATE TABLE "OPS$RM71819"."LOC_DEPTO"
   (	"CD_DEPTO" NUMBER(5,0),
	"NM_DEPTO" VARCHAR2(40 BYTE)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TBSPC_ALUNOS" ;
REM INSERTING into OPS$RM71819.LOC_DEPTO
SET DEFINE OFF;
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('0','Conselho Acionistas');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('10','Financeiro');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('31','Vendas - Região Norte');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('32','Vendas - Região Sul');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('33','Vendas - Região Sudeste');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('34','Vendas - Região Nordeste');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('35','Vendas - Regiao Centro Oeste');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('41','Operacional - Região Norte');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('42','Operacional - Região Sul');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('43','Operacional - Região Sudeste');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('44','Operacional - região Nordeste');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('45','Operacional - Região Centro Oeste');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('50','Administracao Geral');
Insert into OPS$RM71819.LOC_DEPTO (CD_DEPTO,NM_DEPTO) values ('51','Prospeccao de Clientes');
--------------------------------------------------------
--  DDL for Index PK_LOC_DEPTO
--------------------------------------------------------

  CREATE UNIQUE INDEX "OPS$RM71819"."PK_LOC_DEPTO" ON "OPS$RM71819"."LOC_DEPTO" ("CD_DEPTO")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TBSPC_ALUNOS" ;
--------------------------------------------------------
--  Constraints for Table LOC_DEPTO
--------------------------------------------------------

  ALTER TABLE "OPS$RM71819"."LOC_DEPTO" ADD CONSTRAINT "PK_LOC_DEPTO" PRIMARY KEY ("CD_DEPTO")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TBSPC_ALUNOS"  ENABLE;
  ALTER TABLE "OPS$RM71819"."LOC_DEPTO" MODIFY ("CD_DEPTO" NOT NULL ENABLE);