|
-
1) Try with revoking DBA and granting IMPORT_FULL_DATABASE
2) Support pando. Look at the wait events.
To do so, start the imp using interactive mode, enter the username and password. Then the imp will start asking more questions.. stop here, start SQL PLus and issue
select sid, serial# from v$session where upper(program) like '%IMP%';
then issue select on v$session_wait where sid= the sid u found from the first quesry - the event name should be probably SQL Net Message from client
Now get back to the IMP window and continue the import.
When it hang, get back to the SQL window and repeat the query from v$Session_wait. Issue the query several times. See if the event there changes or stays the same.
If it stays the same, post it here and also metalink for it
Good Luck
Boris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|