| Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX [message #505037] |
Thu, 28 April 2011 22:17  |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
Hi,
I am importing the dump.All the tables are getting imported but when it comes to the part as shown in the error it gets struck there and nothing is showed after.what would be the problem and why is it getting struck there.
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Please advice . The dumps for which I am doing the import is huge. Its around 46 GB.
I ran below sql
select
sl.sid,
sl.serial#,
sl.sofar,
sl.totalwork
from
v$session_longops sl,
v$session s,
dba_datapump_sessions d
where
s.saddr = d.saddr
and s.sid = sl.sid
and s.serial# = sl.serial#
order by start_time;
It showing the lock for two sid's. Should I kill the process and import the dump again?
I used below command to import dums
impdp sys/*****@dbname directory=dump_dir dumpfile=prod_dump_%U_200311 SCHEMAS=int_aaa int_bbb int_ccc int_ddd int_eee int_fff
int_ggg int_hhh int_iii int_jjj int_kkk
int_lll
Regards
Ved
[Updated on: Thu, 28 April 2011 22:32] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX [message #505044 is a reply to message #505043] |
Thu, 28 April 2011 23:12  |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
Quote:
I am importing the dump.All the tables are getting imported but when it comes to the part as shown in the error it gets struck there and nothing is showed after.what would be the problem and why is it getting struck there.
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Blackswan,
when I said that was a sample code, and when I said It struck in processing does it matter to provide the orginal connect string name???
Regards
Ved
|
|
|
|
|
|
|
|
| Re: Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX [message #505129 is a reply to message #505045] |
Fri, 29 April 2011 11:17 |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
Quote:
Can it be a disk space problem? I can see the free space as 4.3 M when I used df -u
I solved my problem.I believe.It happened due to space problem.I did free up some space (around 50 gb). I ran the import again and it took 4 hrs to complete. Replying thinking it might help others.
Regards,
Ved
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
