oracle XE impdp.exe problem

From: kiel44 <kiel44_at_poczta.onet.pl>
Date: Wed, 28 Jun 2006 10:33:28 +0200
Message-ID: <e7teso$5k1$1@news.onet.pl>

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\initora.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\RDBMS\ADMIN\catalog.sql @c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\catproc.sql

# start database

sqlplus /nolog
connect / as sysdba
startup pfile=c:\oraclexe\app\oracle\admin\ora\pfile\initora.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 Received on Wed Jun 28 2006 - 03:33:28 CDT