dbTalk Databases Forums  

ORACLE 10g XE impdp problem

comp.database.oracle comp.database.oracle


Discuss ORACLE 10g XE impdp problem in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kiel44
 
Posts: n/a

Default ORACLE 10g XE impdp problem - 06-28-2006 , 03:31 AM






Hi, i have a little proble with Oracle 10g XE.

In our company we have full oracle 10. Now we have to do backup server so we
choose XE edition. But when we trying to imoport *.dmp file with impdp.exe
we have an error.

we did new database like this:

md c:\oraclexe\app\oracle\admin\ora
md c:\oraclexe\app\oracle\admin\ora\adump
md c:\oraclexe\app\oracle\admin\ora\bdump
md c:\oraclexe\app\oracle\admin\ora\cdump
md c:\oraclexe\app\oracle\admin\ora\ddump
md c:\oraclexe\app\oracle\admin\ora\udump
md c:\oraclexe\app\oracle\admin\ora\pfile
md c:\oraclexe\oradata\ora\

set ORACLE_SID=ora

oradim -new -sid %ORACLE_SID% -intpwd ora -startmode M

# c:\oraclexe\app\oracle\admin\ora\pfile\initora.ora #
control_files = (c:\oraclexe\oradata\ora\control01.ctl,
c:\oraclexe\oradata\ora\control02.ctl,
c:\oraclexe\oradata\ora\control03.ctl)
undo_management = auto
db_name = ora
db_block_size = 8192
shared_pool_size = 64M

# start ORA
sqlplus /nolog
connect / as sysdba
startup nomount pfile=c:\oraclexe\app\oracle\admin\ora\pfile\inito ra.ora

# create database
create database ora
logfile group 1 ('c:\oraclexe\oradata\ora\redo1.log') size 32M,
group 2 ('c:\oraclexe\oradata\ora\redo2.log') size 32M,
group 3 ('c:\oraclexe\oradata\ora\redo3.log') size 32M,
group 4 ('c:\oraclexe\oradata\ora\redo4.log') size 32M,
group 5 ('c:\oraclexe\oradata\ora\redo5.log') size 32M
character set EE8ISO8859P2
national character set AL16UTF16
datafile 'c:\oraclexe\oradata\ora\system.dbf'
size 512M
autoextend on
next 64M maxsize unlimited
extent management local
sysaux datafile 'c:\oraclexe\oradata\ora\sysaux.dbf'
size 512M
autoextend on
next 64M
maxsize unlimited
undo tablespace undo
datafile 'c:\oraclexe\oradata\ora\undo.dbf'
size 128M
autoextend on
next 16M maxsize 512M
default temporary tablespace temp
tempfile 'c:\oraclexe\oradata\ora\temp.dbf'
size 128M
autoextend on
next 16M maxsize 512M;

# run scripts
@c:\oraclexe\app\oracle\product\10.2.0\server\RDBM S\ADMIN\catalog.sql
@c:\oraclexe\app\oracle\product\10.2.0\server\RDBM S\ADMIN\catproc.sql

# start database
sqlplus /nolog
connect / as sysdba
startup pfile=c:\oraclexe\app\oracle\admin\ora\pfile\inito ra.ora

and after that when we trying impdp.exe xxx/yyyy we have error

ORA-13206: internal error
ORA-39213: Metadata processing is not available

but when we do imp.exe xxx/yyy .... everything works fine.

Can somebody help me, what i do wrong?

Regards
Marius



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.