Oracle Error 922 Encountered
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-00922 - - errors importing dump file. Joe Echavarria asked Feb 3, 2004 | Replies (4) I am getting this error while trying to import a dump file to my oracle9i database, i have already created the required tablespces..., can anyone t
out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: error during import Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-23-03,10:25 #1 raf View Profile View Forum Posts Registered User Join Date Jul 2002 Posts 227 Unanswered: error during import Hi, I've a export file (XX.dmp). I tried to import this dump for new http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora00922-errors-importing-dump-file-406627 records of tables there are in my db, but I get this errors: imp system/manager@mydb file=xx.dmp tables=A ignore=y fromuser=tom touser=tom log=xx.log Export file created by EXPORT:V09.02.00 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set . importing AFM's objects into AFM IMP-00017: following statement failed with ORACLE error 922: "CREATE TABLE "SITE" ("ACRES" FLOAT(126), "AREA_EM_DP" FLOAT(126) "NOP" VARCHAR2(4)) PC" "TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 4980736 http://www.dbforums.com/showthread.php?794066-error-during-import FREELIS" "TS 1 FREELIST GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS" IMP-00003: ORACLE error 922 encountered ORA-00922: missing or invalid option IMP-00008: unrecognized statement in the export file: ýÿo IMP-00008: unrecognized statement in the export file: R IMP-00008: unrecognized statement in the export file: I think that export file is was corrupted. How Can I import correctly?? Thanks Raf Reply With Quote 05-23-03,11:46 #2 raf View Profile View Forum Posts Registered User Join Date Jul 2002 Posts 227 My db server is 9.0.1, while export made on oracle server 9.2.0.1 On server 9.2.0.1 not is setting the NLS_LANG Could be this the problem??? Thanks Raf Reply With Quote 05-27-03,06:00 #3 AlanP View Profile View Forum Posts Registered User Join Date Mar 2002 Location Reading, UK Posts 1,137 I think it might be the nocompress/compress option available in 9.2 which might be giving you grief. You might want to remove this text from the dmp file using some utility. Alternatively you might try doing the export from the 9.0.1 machine but it might not work. The last option is to create a schema script from 9.2 schema, removing the compress/no compress text. Run the schema script on the 9.0.1 machine and then import with ignore=Y option so it will ignore any create table errors. Alan Reply With Quote 05-27-03,16:46 #4 ravipurbia View Profil
a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed http://docs.oracle.com/cd/B10501_01/server.920/a96525/e900.htm by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed. Action: Correct the syntax or install the Procedural Option. ORA-00901 invalid CREATE command Cause: The CREATE command was not followed by a valid CREATE option. Action: Correct the syntax. ORA-00902 invalid datatype Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid. Action: Correct the syntax. ORA-00903 invalid table name Cause: A table or oracle error cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTER CLUSTER or DROP CLUSTER statement. Action: Check spelling. A valid table name or cluster name must begin with a letter and may contain only alphanumeric characters and the special characters $, _, and #. The name must be less than or equal to 30 characters and cannot oracle error 922 be a reserved word. ORA-00904 string: invalid identifier Cause: The column name entered is either missing or invalid. Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word. ORA-00905 missing keyword Cause: A required keyword is missing. Action: Correct the syntax. ORA-00906 missing left parenthesis Cause: A required left parenthesis has been omitted. Certain commands, such as CREATE TABLE, CREATE CLUSTER, and INSERT, require a list of items enclosed in parentheses. Parentheses also are required around subqueries in WHERE clauses and in UPDATE table SET column = (SELECT...) statements. Action: Correct the syntax, inserting a left parenthesis where required, and retry the statement. ORA-00907 missing right parenthesis Cause: A left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses. All parentheses must be entered in pairs. Action: Correct the syntax and retry the statement. ORA-00908 missing NULL keyword Cause: Either of the following: In a CREATE TABLE or ALTER TABLE statement, NOT was entered to specify that no null values are allowed in tha