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: <fitzjarrell_at_cox.net>
Date: 28 Jun 2006 06:32:30 -0700
Message-ID: <1151501550.558026.257710@x69g2000cwx.googlegroups.com>

kiel44 wrote:
> Thx, but i did that.
> I created new tablespace and user xxx as:
>
> 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 full impdp statment is:
>
> impdp xxx/yyy_at_ora full=Y directory=dumpora dumpfile=sample.dmp
> logfile=impdpDB10G.log
>
> Strange is that, when i do this in XE database everything works fine, but
> when i create new database i have this strange error.
>
> Regards
> Marius
>
> Uzytkownik <vasant.naidu_at_gmail.com> napisal w wiadomosci
> news:1151491698.525855.53960_at_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
> >

You did not create a complete catalog; below is the full list of catalog scripts you should have executed, in their proper order:

@c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\catalog.sql
@c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\catblock.sql
@c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\catproc.sql
@c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\catoctk.sql
@c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\owminst.plb

Connect as SYS to your XE instance and execute them; you'll likely find impdp.exe works as expected on your new database.

David Fitzjarrell Received on Wed Jun 28 2006 - 08:32:30 CDT

Original text of this message

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