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 |