Menu de navegação

[leandrolbsParticipante]

se via execução ele conecta, e via parâmetro não, tem duas possibilidades, ou as informações estão erradas, ou os espaços e caracteres estão dando “trabalho”…

pois via exp
usuario>
senha>
buffer>
file>

funcionou!…

[joffreParticipante]

Fui apertando após aquela mensagem que postei para você, e o backup foi feito.

Abaixo, tudo o que apareceu no prompt para mim:


G:DBMS_Engine_FilesORACLEOracle9ibin>exp

Export: Release 9.2.0.1.0 - Production on Tue Apr 26 11:36:59 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Username: TS_F_ORA9_GDT@SRV-TSBD-9I
Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP >
(2)U(sers), or (3)T(ables): (2)U >
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TS_F_ORA9_GDT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TS_F_ORA9_GDT
About to export TS_F_ORA9_GDT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TS_F_ORA9_GDT's tables via Conventional Path ...
. . exporting table ABONHIST 0 rows exported
. . exporting table ACAOCRONOG 9 rows exported
. . exporting table ACAOPREVENTIVA 12 rows exported
. . exporting table ACIDENTE 4 rows exported
. . exporting table ACOESAUT 0 rows exported
. . exporting table ACOESHAB 0 rows exported
. . exporting table ACOESPREVPCMSO 0 rows exported
. . exporting table ADICIONA 0 rows exported
. . exporting table ADICIONAISCAMPOS 9 rows exported
. . exporting table ADICIONAISVALOR 0 rows exported
. . exporting table ADVOGADO 0 rows exported
. . exporting table AFASTA 0 rows exported
. . exporting table AFASTAMENTOS 4 rows exported
. . exporting table AFASTBENEFICIOS 0 rows exported
. . exporting table AGENDAAUTOPER 12 rows exported
. . exporting table AGENDAMENTOS 9 rows exported
. . exporting table AGENDAMOTIVOAUSEN 5 rows exported
. . exporting table AGENDAMOTIVOBLOQ 4 rows exported
. . exporting table AGENDAMOTIVOCANC 4 rows exported
. . exporting table AGENDARECTREIN 3 rows exported
. . exporting table AGENDAS 1 rows exported
. . exporting table AGENLISTAESPERA 2 rows exported
. . exporting table AGENTECAUSADOR 293 rows exported
. . exporting table AGRUPAMENTOCID 21 rows exported
. . exporting table ALTERTAB 3481 rows exported
. . exporting table ANEXO 0 rows exported
. . exporting table APOSENTADORIA 0 rows exported
. . exporting table APROVPAT 1 rows exported
. . exporting table AREAATUA 18 rows exported
. . exporting table AREACANDIDATO 3 rows exported
. . exporting table AREAPOSICAO 0 rows exported
. . exporting table ASOFUNC 202 rows exported
. . exporting table ASOPEDEXAMEAUDIOMETRIA 0 rows exported
. . exporting table ASSISTECNICO 0 rows exported
. . exporting table ASSOCEVERES 0 rows exported
. . exporting table ASSOCIACAOBENEFOPER 0 rows exported
. . exporting table ASSOCMEDPRINCATIV 0 rows exported
. . exporting table ASSUNTO 24 rows exported
. . exporting table ATENAFASVINCULO 0 rows exported
. . exporting table ATENDIMENTO 8 rows exported
. . exporting table ATENDIMENTOOBS 0 rows exported
. . exporting table ATENDPROCENFERMARIA 0 rows exported
. . exporting table ATIVFUNCAO 0 rows exported
. . exporting table ATOINSEGURO 5 rows exported
. . exporting table ATRIBADIC 0 rows exported
. . exporting table ATRIBENT 0 rows exported
. . exporting table ATRIBFUN 45 rows exported
. . exporting table ATRIBFUNHIST 0 rows exported
. . exporting table ATRIBPERFILPROFIS 0 rows exported
. . exporting table ATRIBREL 539 rows exported
. . exporting table ATRIBUICOESBRIGADA 3 rows exported


Aí vai indo até concluir…

. . exporting table WKF_EXPRESSOESFILTRO 0 rows exported
. . exporting table WKF_EXPRESSOESPARAMETROS 5 rows exported
. . exporting table WKF_FILTRO 0 rows exported
. . exporting table WKF_FILTRODEUSUARIO 0 rows exported
. . exporting table WKF_FORMPARAM 22 rows exported
. . exporting table WKF_FORMULA 0 rows exported
. . exporting table WKF_FUNCAODINAMICA 0 rows exported
. . exporting table WKF_GRUPODEACOES 6 rows exported
. . exporting table WKF_GRUPODEPARAMETROS 0 rows exported
. . exporting table WKF_GRUPOHIERARQUIA 35 rows exported
. . exporting table WKF_INFORELATORIOGERADO 0 rows exported
. . exporting table WKF_INSTANCIADECONCEITO 41 rows exported
. . exporting table WKF_INSTANCIADEPROCESSO 0 rows exported
. . exporting table WKF_INSTRUCAO_SQL 109 rows exported
. . exporting table WKF_LEITORDOPROCESSO 7 rows exported
. . exporting table WKF_LISTA 0 rows exported
. . exporting table WKF_LISTADEPARAMETROS 58 rows exported
. . exporting table WKF_LISTAGRUPOORDENACAO 1 rows exported
. . exporting table WKF_LISTAHISTORICO 0 rows exported
. . exporting table WKF_LISTAMAPASVALOR 0 rows exported
. . exporting table WKF_LISTAMAPASVALORHISTORICO 0 rows exported
. . exporting table WKF_LISTA_EXPS_FILTRO 0 rows exported
. . exporting table WKF_MAPADEVALORES 0 rows exported
. . exporting table WKF_MAPADEVALORESHISTORICO 0 rows exported
. . exporting table WKF_MAPEAMENTOCAMPOS 5 rows exported
. . exporting table WKF_MAPEAMENTO_EXCECAO_OBJCOM 6 rows exported
. . exporting table WKF_MAPECAMPOSCOL 3 rows exported
. . exporting table WKF_MENSAGEMDEEMAIL 68 rows exported
. . exporting table WKF_MENSAGEM_EML 0 rows exported
. . exporting table WKF_MODELODEFONTEDEDADOS 4 rows exported
. . exporting table WKF_MODELODETELA 3 rows exported
. . exporting table WKF_NEC_ODD 8 rows exported
. . exporting table WKF_NOMESALVOS 0 rows exported
. . exporting table WKF_NOMESATIVIDADES 0 rows exported
. . exporting table WKF_NOMESDOSPROCESSOS 0 rows exported
. . exporting table WKF_NOMESRESPONSAVEIS 0 rows exported
. . exporting table WKF_NOMESSOLICITANTES 0 rows exported
. . exporting table WKF_OBS_ATH 0 rows exported
. . exporting table WKF_ODD_FUNCAONEGOCIO 17 rows exported
. . exporting table WKF_ODD_FUNCAOSQL 36 rows exported
. . exporting table WKF_ORDEM_REGRAS 0 rows exported
. . exporting table WKF_ORIGEMDADOSCATEGORIA 8 rows exported
. . exporting table WKF_ORIGEMDEDADOS 58 rows exported
. . exporting table WKF_PAPELUSUARIO 0 rows exported
. . exporting table WKF_PARAMETRO 123 rows exported
. . exporting table WKF_PARAMETRODERELATORIO 3 rows exported
. . exporting table WKF_PARAMFDD 28 rows exported
. . exporting table WKF_PENDENCIATAREFA 0 rows exported
. . exporting table WKF_PROCESSOHISTORICO 0 rows exported
. . exporting table WKF_REGISTROS 0 rows exported
. . exporting table WKF_REGISTROSHISTORICO 0 rows exported
. . exporting table WKF_REGRAS 0 rows exported
. . exporting table WKF_REGRA_REDIRECIONAMENTO 0 rows exported
. . exporting table WKF_RELMAPEADOS 0 rows exported
. . exporting table WKF_REL_ATFDD_ATR 242 rows exported
. . exporting table WKF_REL_CFGA_RED 0 rows exported
. . exporting table WKF_REL_COLPARAMSFDD_PARAMFDD 28 rows exported
. . exporting table WKF_REL_CONSISTENCIA_PARAMETRO 4 rows exported
. . exporting table WKF_REL_CONSIST_FORM 3 rows exported
. . exporting table WKF_REL_DGH_ATH 0 rows exported
. . exporting table WKF_REL_EMA_USU_DESTBCC 0 rows exported
. . exporting table WKF_REL_EMA_USU_DESTCC 0 rows exported
. . exporting table WKF_REL_EMA_USU_DESTSIMPLES 17 rows exported
. . exporting table WKF_REL_FDI_PRM 0 rows exported
. . exporting table WKF_REL_FORMULA_PARAMETRO 0 rows exported
. . exporting table WKF_REL_GDP_LDP 0 rows exported
. . exporting table WKF_REL_GRP_TFA 0 rows exported
. . exporting table WKF_REL_LEI_GRP_GPDEHIERARQUIA 9 rows exported
. . exporting table WKF_REL_LEI_RSP_RESPEXISTENTES 0 rows exported
. . exporting table WKF_REL_MFDD_ATR 41 rows exported
. . exporting table WKF_REL_MFDD_IODD 41 rows exported
. . exporting table WKF_REL_MFDD_LDP 39 rows exported
. . exporting table WKF_REL_NEC_CAMPOLISTAGEM 1 rows exported
. . exporting table WKF_REL_NEC_CAMPOVALOR 31 rows exported
. . exporting table WKF_REL_NEC_IODD 0 rows exported
. . exporting table WKF_REL_ODDFN_PRM 51 rows exported
. . exporting table WKF_REL_ODD_PARAMETRO 68 rows exported
. . exporting table WKF_REL_RESP_GH 30 rows exported
. . exporting table WKF_REL_VALPREEN_LIST 1 rows exported
. . exporting table WKF_RESPONSAVEL 31 rows exported
. . exporting table WKF_RESTRICAODOFILTRO 0 rows exported
. . exporting table WKF_RETORNOMAPEADO 72 rows exported
. . exporting table WKF_SENTENCAABSTRATA 1 rows exported
. . exporting table WKF_SERVIDORDEEMAIL 2 rows exported
. . exporting table WKF_SOLICITANTESDOPROCESSO 4 rows exported
. . exporting table WKF_TAREFA 0 rows exported
. . exporting table WKF_TIPODECONTROLE 38 rows exported
. . exporting table WKF_TIPODEGRUPO 0 rows exported
. . exporting table WKF_TIPODEPROCESSO 1 rows exported
. . exporting table WKF_TIPOEXECUCAO 6 rows exported
. . exporting table WKF_USUARIOEMAIL 30 rows exported
. . exporting table WKF_VALOR 0 rows exported
. . exporting table WKF_VALORDEPREENCHIMENTO 1 rows exported
. . exporting table WKF_VALORDOPARAMRELATORIO 3 rows exported
. . exporting table WKF_VALORESDELISTAGEM 1 rows exported
. . exporting table WKF_VALORESDETELAHISTORICO 13 rows exported
. . exporting table WKF_VALORESDOMAPA 0 rows exported
. . exporting table WKF_VALORESDOMAPAHISTORICO 0 rows exported
. . exporting table WKF_VALORESPARAM 14 rows exported
. . exporting table WKF_VALORESTABELA 200 rows exported
. . exporting table WKF_VALORHISTORICO 0 rows exported
. . exporting table WKF_VALORMEMORANDO 0 rows exported
. . exporting table WKF_VALORMEMORANDOHISTORICO 0 rows exported
. . exporting table WKF_VALORPADRAOMEMORANDO_ATR 0 rows exported
. . exporting table WKF_VALORVINC_PARAM 28 rows exported
. . exporting table WKF_VERSAODOBANCO 1 rows exported
. . exporting table WKF_XOML 2 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

G:DBMS_Engine_FilesORACLEOracle9ibin>

[leandrolbsParticipante]

use o exp com parametros agora, mas só use usuario/senha@banco file= log= buffer=

[joffreParticipante]

Funcionou!

Usei o seguinte código:
exp TS_F_ORA9_GDT/tsoracle9i@SRV-TSBD-9I file=D:LOG_GDTbackupJoffre.dmp log=D:LOG_GDTlogJoffre.txt buffer=4096
Pode me explicar qual a utilidade desse buffer?

Obrigado pela ajuda.
Agora vou tentar fazer a importação.

Se puder já me dar uma dica para eu evitar um novo tópico, agradeço!

[leandrolbsParticipante]

na realidade o erro é no owner= , não é necessário informar se o usuario a exportar é proprio usuario logado.

O buffer é o tamanho de uso, isso deixa o export mais rapido.

[joffreParticipante]

[quote=”leandrolbs”:1qq9ct9h]na realidade o erro é no owner= , não é necessário informar se o usuario a exportar é proprio usuario logado..[/quote]

Hein!?

Enfim… deu certo!!! 🙂

Obrigado pela ajuda.

[Autor]

Posts