export oracle database 11g sqldeveloper

Question

The point is, 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, with exactly the same structure, that is everything in my local connection, I wanted to export to another machine, creating a local repository, could someone help me ? Use the sqldeveloper 11g follows the image with the structure I want to export..!

Answer 1

Observing:
First of all, I recommend running a test on 2 banks to see if the expected result meets your problem.

You can use the Database Copy Wizard, available in the menu:

Ferramentas > Cópia de Banco de Dados

In the first step select the source and destination and the options that most make sense to you, select "Replace existing destination objects", and "Truncate destination before copying", to clear everything before copying:

In the second stage, the types of objects, in this case I left marked all:

Then specify all objects by clicking on research,and then in >>

If you want you can specify some data, I did nothing at this stage:

And then Finish:

Will sue:

And generate a log with the copy:

Opção de Cópia: Cópia de Objetos
Conexão de Origem: teste1
Conexão de Destino: teste2
Objetos DDL:
Views
Tudo Views
Tipos
Tudo Tipos
Links de Banco de Dados
Tudo Links de Banco de Dados
Tabelas
TESTE1.TABLE1
Sequências
Tudo Sequências
Views Materializadas
Tudo Views Materializadas
Índices
TESTE1.H_ID
Triggers
Todos Triggers para TESTE1.TABLE1
Logs de Views Materializadas
Tudo Logs de Views Materializadas
Procedures
Tudo Procedures
Pacotes
Tudo Pacotes
Corpos de Packages
Tudo Corpos de Packages
Funções
Tudo Funções
Objetos de Dados:
Tabelas
TABLE1
Copiar DDL: Sim
Substituir
Copiar Dados: Sim
--- START --------------------------------------------------------------------
  DROP TABLE "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 --------------------------------------------------------------------

One detail, which may not make a difference to you, is that it uses the same tablespace from source, not to exchange, even if you previously set that the user will use such tablespace, fate will remain the same tablespace of origin.