The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Advanced & Expert Users
Google UNIX.COM


UNIX for Advanced & Expert Users Advanced UNIX and Linux questions go here. Expert-to-Expert.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
x 86 svccfg import error oscarl SUN Solaris 1 02-22-2008 10:01 AM
Error, Login Limit Exceeded by 1 user nchrocc UNIX for Dummies Questions & Answers 1 08-14-2006 06:21 AM
import omran UNIX for Dummies Questions & Answers 1 01-26-2003 10:10 PM
import omran Shell Programming and Scripting 2 12-17-2002 11:47 AM
Error login user file utmp jernesto_diaz UNIX for Dummies Questions & Answers 3 09-06-2002 08:36 AM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 04-22-2008
Registered User
 

Join Date: Apr 2008
Posts: 39
Talking error during import user

Hi....
First i export the full.dmp file from Prod server (oracle 9i , Solaris 9) to this server (10g 10.2.0.3, Linux). Then when i try to import a user, error come out....


Import: Release 10.2.0.3.0 - Production on Tue Apr 22 17:59:41 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing SPMP's objects into SPMP
illegal lob length marker 65535
bytesread = 00000000000
TABLE =
IMP-00098: INTERNAL ERROR: impgst2Segmentation fault
-bash-3.1$
Reply With Quote
Forum Sponsor
  #2  
Old 04-23-2008
...@...
 

Join Date: Feb 2004
Location: NM
Posts: 4,298
Look in metalink (metalink.oracle.com) or call Oracle support. Any time you see INTERNAL ERROR with Oracle you usually need a metalink search at a minimum
Reply With Quote
  #3  
Old 04-23-2008
radoulov's Avatar
addict
 

Join Date: Jan 2007
Location: Milano, Italia/Варна, България
Posts: 1,935
Try it with different recordlength (for example recordlength=65535).

P.S. And set the character set correctly
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 09:36 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0