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: kiel44 <kiel44_at_poczta.onet.pl>
Date: Thu, 29 Jun 2006 04:01:38 +0200
Message-ID: <e7vca3$lgr$1@news.onet.pl>


Hi again

 i don't have XE instance. I did my own - ora.

I did as you wrote but in XE there is no c:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\ADMIN\owminst.plb file.

Other files make errors because they are trying to run other *.sql files but Oracle XE doesn't have them.

impdp.exe still don't work :(

Uzytkownik <fitzjarrell_at_cox.net> napisal w wiadomosci news:1151501550.558026.257710_at_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 - 21:01:38 CDT

Original text of this message

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