Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle XE impdp.exe problem

Re: oracle XE impdp.exe problem

From: <vasant.naidu_at_gmail.com>
Date: 28 Jun 2006 03:48:18 -0700
Message-ID: <1151491698.525855.53960@m73g2000cwd.googlegroups.com>


Hi Marius,

Read the datapump usage document. You might need to create and use a database directory.

Example:
SQL> create directory dmpdir as '/home/exp'; Directory created.

SQL> grant read, write on directory dmpdir to tp; Grant succeeded.

after this try to use your impdp with the required parameters.

Regards,
Vasant

kiel44 wrote:
> 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 - 05:48:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US