Oracle Sql Error 922
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-00922: missing or invalid option tips Oracle Error Tips by Burleson Consulting The Oracle docs note this on the ora-00922 error*: ORA-00922 missing or invalid option Cause: An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error. Action: Correct the syntax. Remove the erroneous option or length specification from the column or storage specification. If an invalid option is specified while defining a storage clause or column, ORA-00922 will be thrown. ORA-00922 mentions that to specify that the column is not able to contain any NULL values, the valid option while specifying a column is NOT NULL, and solely constraints can follow the datatype. Also notable to ORA-00922, which can also cause this error to be thrown, is that specifying a maximum length on LOG or DATE datatype. Correcting ORA-00992 consists of correcting the syntax in your specifications, minding to take out the erroneous option or length specification from the storage of column specification. �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, wCommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 2 Replies Latest reply on May 28, 2010 6:42 AM by 774686 Special character when changing password in sql plus 774686 May 28, 2010 6:35 AM Hi i'm having a problem with setting password for user's in sql plus. http://www.dba-oracle.com/t_ora_00922_missing_or_invalid_option.htm I get a ORA-00922 whenever I try to change a user's password to contain ! in it. See below. Do I have to escape special characters or something or this a bug? (Previously I've always used Enterprise Manager for this and can set ! characters for password without issue but we're currently having an issue with it and I need to alter passwords in sql plus https://community.oracle.com/thread/1080935 while I'm waiting for it to be fixed ) SQL> alter user lbtest identified by oraclesux!; alter user lbtest identified by oraclesux! * ERROR at line 1: ORA-00922: missing or invalid option SQL> alter user lbtest identified by oraclesux; User altered. System and O/S details below: O/S = MS Server 2008 Standard Service Pack 1 64 bit Oracle 11g Standard Edition (11.1.0.7.0) SQL> select * from nls_database_parameters; PARAMETER VALUE ---------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8MSWIN1252 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM PARAMETER VALUE ---------------------------------------- NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 11.1.0.7.0 20 rows selected. I have the same question Show 0 Likes(0) 26572Views Tags: none (add) alter_user_identified_byContent tagged with alter_user_identified_by, ora-00922Content tagged with ora-00922, passwordContent tagged with password This content has been marked as final. Show 2 replies 1. Re: Special character when changing password in sql plus 774686 May 28, 2010 6:41 AM (in response to 774686) Found the answer here, must user double quote for exclamation marks but not other characters like #. http://as
did not see where looking for a long time, but fortunately the Internet can find the same problem now solved, specially the solution to Favorites down ~ TrackBack URL: Dmp file importing and exporting the following error when the file created by EXPORT: V09.02.00 via conventional path export .... IMP-00017: following statement failed with ORACLE 922 error IMP-00003: ORACLE error encountered 922 ORA-00922: missing or invalid option IMP-00017: following statement failed with ORACLE 922 error Again the parameters indexfile import file to create a statement object, paste sqlplus perform this parameter nocompress that, rooted in the version of the problem, export data server and client versions are 9.2, import the data server and the client version is 9.0 , but has not then 9.0 client to turn on the data. We can only use the DMP Files. Began to think is to modify export indexfile option sql files, create the table structure, you can complete. However, import the dmp file again or can not continue. This can only change the dmp file to open dmp file ultraedit32, character of positioning nocompress, all of these characters into spaces, spaces ascii code 32, 16 decimal is 20, that is, all the characters into the nocompress contained 20. Re-import the dmp file successfully. But editing the dmp file is always a dangerous thing, do not know there is no way to create the table structure to skip these table structure definition statement to import data directly method. I found in the data file TABLESPACE "USERS" LOGGING the NOCOMPRESS "are actually not, and their presence is the root cause of the different versions of the database file can not be imported to replace all the spaces, the problem can be solved. Note: the number of replacement must pay attention to spaces and replace text, otherwise it will go wrong! ============================================= On original content, in accordance with the method can solve the problem, in which elaborate on what this said replace nocompress, EmEditor available tools to open, to select ASCII code to open the English document is not changed, so it is easy to find replaced. ~! Recommended Paging stored procedure OVRDBF command RMAN backup in Windows Getting Started learning (1) VC + + 6.0 - Release single-step debugging sql server database password vulnerability _ Database Sec