impdp.exe problem

From: kiel44 <kiel44_at_poczta.onet.pl>
Date: Wed, 28 Jun 2006 14:57:33 +0200
Message-ID: <e7tuc3$cit$1_at_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 import *.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

_at_c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\catalog.sql _at_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

O course I created new tablespace and user xxx as follow:

CREATE TABLESPACE sample DATAFILE 'C:\oraclexe\oradata\sample.dbf' SIZE 100M;

CREATE USER xxx IDENTIFIED BY yyy DEFAULT TABLESPACE sample TEMPORARY TABLESPACE TEMP;
GRANT UNLIMITED TABLESPACE TO xxx;

GRANT "CONNECT" TO xxx;
GRANT "DBA" TO xxx;
GRANT "RESOURCE" TO xxx;

CREATE OR REPLACE DIRECTORY dumpora AS 'c:\backup_ora'; GRANT READ, WRITE ON DIRECTORY dumpora TO xxx;

and my full impdp.exe statment is:

impdp xxx/yyy_at_ora full=Y directory=dumpora dumpfile=sample.dmp logfile=impdpDB10G.log

[Quoted] Strange is that, when I do this in XE database everything works fine, but when I create new database ora I have this error.

Can somebody help me, what i do wrong?

ps. imp.exe . works fine as always.

Regards
Marius Received on Wed Jun 28 2006 - 14:57:33 CEST