SQL> produce user mehmet identified through deveci!2 develop user mehmet determined by deveci!*ERROR in ~ heat 1:ORA-00922: missing or inprecious optionORA-00922 absent or inprecious optionCause: one invalid choice was specified in specifying a Column or storAge clause. Ns valid option in specifying a Pillar ins not NULl to point out that the Shaft canno save on computer any type of NULl values. Just constraints may folshort ns datatype. Specifyinns a preferably length on a date or lengthy datakind additionally reasons thins error.Action: exactly the syntax. Remove ns erroneouns alternative or size specificati~ above from theTower or storPeriod specification.

You are watching: Ora-00922: missing or invalid option

missing or inprecious option

Thins ORA-00922 errors are associated with ns invalid alternative was mentioned in specifying a Column or storAge clause.

the precious alternative in specifying a Obelisk is not NULtogether to point out the the Shaft cannotcontain any kind of NULl values. Only constraintns might follow the datatype. Specifyinns a maximumlength ~ above a day or long datatype additionally reasons this error.

come settle thins error, you must correct ns syntax.

Or you need to remove ns erroneous choice or length specificatitop top native ns Tower or storEra specification.

SQL> create user mehmet identified by deveci!;2 produce user mehmet established through deveci!*ERROR at line 1:ORA-00922: absent or inprecious option

to solve this error, add ” ” to password as follows, difficulty will it is in solved.

SQL> produce user mehmens identified through "deveci!";User created.

largely this error ins caused Since of missing comma or added comma or dot.

for this reason exactly the syntaxation of SQtogether Statement.

execute friend want come Learn Oracle Databasic for Beginners, climate reAD ns complying with articles.

See more: Dottie Rambo Sheltered In The Arms Of God ", Dottie Rambo

Oracle Tutorial | Oracle Databasic Tutorialns because that beginners ( junior Oracle DBA )

919see last month, 1views today


i am Founder of SysDBASofns Ins and It Tutoriatogether and Certified skilled around Oracle & SQl Server database, Goldengate, Exainformation Machine, Oracle Databasic Appliance administrator with 10+years experience.i have OCA, OCP, OCE RAC experienced certificate i have worked 100+ Banking, Insurance, Finance, Telco and also and so on client as a Consultant, Insource or Outsource.i have actually done 200+ Operation in thins clients together as Exadata installation & PoC & migration & Upgrade, Oracle & SQtogether Server Databasic Upgrade, Oracle RAC Installation, SQl Server Alwayboy Installation, Databasic Migration, disaster Recovery, Back-up Restore, power Tuning, regular Healthchecks.i have da 2000+ Table replication via Goldendoor or SQl Server Replicati~ above Device for DWH Databasens in many type of clients.If you require Oracle DBA, SQtogether Server DBA, APPns DBA, Exadata, Goldengate, EBs Consultancy and also Train girlfriend have the right to send mine email adress .- -Oracle DBA, SQl Server DBA, APPns DBA, Exadata, Goldengate, EBs ve linux Danışmanlık ve Eğitim için  a mail atabilirsiniz.