-----Ursprüngliche Nachricht-----
Von: Hahner Karlheinz SGD FIRS
Gesendet: Donnerstag, 31. Mai 2007 08:41
An: 'Purusottam Kaushik '
Betreff: AW: Import Problem
Try to check if the parameter NLS_LENGTH_SEMANTICS is set to byte BYTE (this is default).
(select * from nls_database_parameters)
Depending on how the characters are stored it could be up to 4Byte in UTF-8.
This means that eg. an varchar2(3000) variable could store only 750 characters if "strange" ones are used....
You can try using "alter system set nls_length_semantics='CHAR'" and try to import this table "ZIPS" in a test system.
With nls_length_semantics='CHAR' a varchar2(3000) will reserve 3000 characters, no matter how much bytes the characters needs.
The other problem could be that the importing user hasn't got the right to execute the "alter session set NLS_LENGTH_SEMANTICS = 'BYTE'".
Try to check this first.
Hope this helps.
Karl
-----Ursprüngliche Nachricht-----
Von: Purusottam Kaushik [mailto:oracledba-ezmlmshield-x64676211.[Email address protected]
Gesendet: Mittwoch, 30. Mai 2007 19:01
An: LazyDBA Discussion
Betreff: Import Problem
Hi ORACLE GURUS,
While performing import on oracle 10G my import command terminate with following error.
. . importing table "ZIPS" 73136 rows imported
IMP-00017: following statement failed with ORACLE error 2248:
"ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL = 1 NLS_LENGTH_SEMANTICS = 'BYTE'
PL"
"SQL_CODE_TYPE = 'INTERPRETED' PLSQL_DEBUG = FALSE PLSQL_WARNINGS = 'DISABLE"
":ALL'PLSQL_CCFLAGS = ''"
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully
Please help me with problem. Thanks in advance.
Thanks
Purusottam Kaushik
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html
----------------
Vorsitzender des Aufsichtsrats: Hans-Georg Härter
Geschäftsführung: Egon Behle (Vorsitz), Rolf Bulander, Wolfgang Runge, Karl-Heinz Schrödl, Wolfgang Zeitz
Sitz: Schwäbisch Gmünd - Handelsregistereintrag: Amtsgericht Ulm HRB 701678
Oracle LazyDBA home page