export import database oracle 11g sqldeveloper

2

The question is as follows, I have a local database, where I already have the structure and data in the respective tables that I need. I want to export this database to another machine, exactly the same structure, that is everything in my local connection, I wanted to export to another machine, creating a local repository, could anyone help me? I use sqldeveloper 11g follows the image with the structure I want to export ..!

    
asked by anonymous 24.08.2017 / 15:38

1 answer

0
  

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.

    
24.08.2017 / 16:20