Note:
First of all, I recommend that you test two banks to see if
the expected result caters to your problem.
You can use the Database Copy Wizard feature, available from the menu:
Ferramentas > Cópia de Banco de Dados
In the first step select the source and destination and the options that make the most sense to you, I selected "Replace existing destination objects", and "Truncate destination before copying", to clean everything before making the copy:
Inthesecondstep,thetypesofobjects,inthiscaseImarkedall:
Thenspecifyallobjectsbyclickingsearch,andthen>>
Ifyouwantyoucanspecifysomedata,Ididnothingatthisstep:
ThenFinish:
Reporting:
Andgeneratealogwithcopy:
OpçãodeCópia:CópiadeObjetosConexãodeOrigem:teste1ConexãodeDestino:teste2ObjetosDDL:ViewsTudoViewsTiposTudoTiposLinksdeBancodeDadosTudoLinksdeBancodeDadosTabelasTESTE1.TABLE1SequênciasTudoSequênciasViewsMaterializadasTudoViewsMaterializadasÍndicesTESTE1.H_IDTriggersTodosTriggersparaTESTE1.TABLE1LogsdeViewsMaterializadasTudoLogsdeViewsMaterializadasProceduresTudoProceduresPacotesTudoPacotesCorposdePackagesTudoCorposdePackagesFunçõesTudoFunçõesObjetosdeDados:TabelasTABLE1CopiarDDL:SimSubstituirCopiarDados:Sim---START--------------------------------------------------------------------DROPTABLE"TABLE1" cascade constraints;
Table "TABLE1" eliminado.
--- END --------------------------------------------------------------------
--- START --------------------------------------------------------------------
set define off;
--------------------------------------------------------
-- DDL for Table TABLE1
--------------------------------------------------------
CREATE TABLE "TABLE1" ("NAME" VARCHAR2(255 BYTE), "ID" NUMBER, "COLUMN2" VARCHAR2(50 BYTE), "COLUMN3" VARCHAR2(2000 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 "TESTE1_INDEX" ;
Table "TABLE1" criado.
--- END --------------------------------------------------------------------
--- START --------------------------------------------------------------------
--- END --------------------------------------------------------------------
--- START --------------------------------------------------------------------
TRUNCATE TABLE "TABLE1";
Table "TABLE1" truncado.
--- END --------------------------------------------------------------------
--- START --------------------------------------------------------------------
Movendo Dados do objeto TABLE1
Inserir 10.000 linhas em TABLE1 em 2.321 milissegundos
--- END --------------------------------------------------------------------
--- START --------------------------------------------------------------------
set define off;
--------------------------------------------------------
-- DDL for Index H_ID
--------------------------------------------------------
CREATE INDEX "H_ID" ON "TABLE1" ("ID") 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 "TESTE1_INDEX" ;
Index "H_ID" criado.
set define off;
set define off;
--- END --------------------------------------------------------------------
--- START --------------------------------------------------------------------
--- END --------------------------------------------------------------------
A detail that may make no difference to you is that it uses the same% s of% of the source, not to change, even if you previously set the user to use that tablespace
, the destination will have the same as% of origin.