Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

error during import user

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users error during import user
# 1  
Old 04-23-2008
Computer 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$
# 2  
Old 04-23-2008
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
# 3  
Old 04-23-2008
Try it with different recordlength (for example recordlength=65535).

P.S. And set the character set correctly Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Zpool import/export error

A backup/clone script of ours was recently ran. It normally only clones the rpool and renames in rpoolA. Something must've changed as it found another one of our pools that it shouldn't have. It exported that pool unbeknownst to us. Later on when a coworker realized the other pool was missing he... (2 Replies)
Discussion started by: beantownmp
2 Replies

2. Shell Programming and Scripting

How to import a value from txt file

Hello, I want to give a value from a txt file to my variable at my ksh script. I`ve searched on the net and I found the command variable < file.txt but it cannot see the file. The .txt file contains two values in the first and the second line. Is there any way to give the first-line value to... (1 Reply)
Discussion started by: chris_euop
1 Replies

3. Shell Programming and Scripting

export / import

I have a calling script which consists of calls to other scripts via the sh command. ie vi callscript.sh sh smallscript1.sh extra unix commands sh smallscript2.sh exit In smallscript1, I prompt for a filename, which I handle via :- read f1 export f1 I then need... (5 Replies)
Discussion started by: malts18
5 Replies

4. Shell Programming and Scripting

is it possible import the variable ?

Hi All, I need to hold one variable in another script. I mean, i will be running 1st script say ScriptA which should import one variable from another script say ScriptB. I will be incrementing the variable everyday in ScriptA and want to place it in ScriptB.The next day i should get the... (2 Replies)
Discussion started by: vinayakatj56
2 Replies

5. Solaris

How to import the new service

Hi How to import the new service which i created without root permission. As well how we can set the uid in service. When i import i got the following error, svccfg import /var/svc/manifest/site/newservice.xml svccfg: Could not create temporary service "TEMP/site/newservice"... (6 Replies)
Discussion started by: kalpeer
6 Replies

6. Shell Programming and Scripting

Import variable

Can i import a value of a variable in a different related script. (2 Replies)
Discussion started by: manish.s
2 Replies

7. Solaris

x 86 svccfg import error

I get this error I have a laptop with solaris 10 x86 installed How can I go about this Thank you State: offline Reason: Start method is running See: Sun Message ID: SMF-8000-C4 See: /etc/svc/volatile/system-install-discovery:default.log Impact: 11 dependent services are not running:... (1 Reply)
Discussion started by: oscarl
1 Replies

8. Shell Programming and Scripting

exceptions in import

Hello, I want to import an Oracle database file on my fresh DB, bought before successfully with exp command. But is it possible to import some tables from the dmp file, because they are too large and it's so long !? I didn't find any option in imp command to make exception on certain tables...... (1 Reply)
Discussion started by: madmat
1 Replies

9. UNIX for Dummies Questions & Answers

import

Dear All, If while the databsae was shut down, an import command has been done. Will the import result will return 1? Best Regards, Omran (1 Reply)
Discussion started by: omran
1 Replies

10. Shell Programming and Scripting

import

i'm importing tables to oracle 7, but sometimes import give me warnings (not failures) how can i rollback the whole imported tables if warnings occured please advise thanx (2 Replies)
Discussion started by: omran
2 Replies
Login or Register to Ask a Question