Re: oracle XE impdp.exe problem

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
>
Received on Wed Jun 28 2006 - 07:50:18 CDT