|
안녕하세요.
현재 프로젝트 진행중에 있는데요.
실서버인 10g 64bit에서 실데이타를 제외한 테이블,뷰,함수등등의 스키마 구조만 export받아서
개발서버인 11g로 import할려는데요.
명령어를 넣으니까 export중에 에러가 나서 구글질하다가 해결방법이 있나해서 질문드립니다.
먼저 개발서버인 10g sys계정은 접근할수 없구요.
현재 작업pc의 오라클버전은 11g 입니다.
아래는 제가 사용한 실행문입니다.
C:\oraclexe\app\oracle\product\11.2.0\server\bin\exp.exe 계정/암호@dbsid FILE='C:\oraclexe\app\oracle\oradata\test\test.dmp' GRANTS=Y INDEXES=Y ROWS=N CONSTRAINTS=Y TRIGGERS=Y COMPRESS=N DIRECT=N CONSISTENT=N OWNER=(계정)
실행결과
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set
server uses KO16KSC5601 character set (possible charset conversion)
Note: table data (rows) will not be exported
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user LGMJETT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user LGMJETT
About to export LGMJETT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export LGMJETT's tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully
|
