error: ORA-65096: invalid common user or role name in oracle

I just installed Oracle, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of Scott schema, but when i try to run the query:

create user Scott identified by tiger;

it displays the following error:

ORA-65096: invalid common user or role name in oracle.

Basically it is not allowing me to create a user Scott.

Why is that, and how can I fix my problem?

Related Posts:

  1. ORA-28040: No matching authentication protocol exception
  2. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  3. How do I use CREATE OR REPLACE?
  4. ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
  5. ORA-00904: invalid identifier
  6. SQL error “ORA-01722: invalid number”
  7. how to fix oracle ORA-01722 invalid number error
  8. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  9. QL Error: ORA-00933: SQL command not properly ended
  10. ORA-00979 not a group by expression
  11. ORA-00907: missing right parenthesis
  12. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  13. ORA-12154 could not resolve the connect identifier specified
  14. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  15. ORA-01843 not a valid month- Comparing Dates
  16. SQL Error: ORA-00942 table or view does not exist
  17. ORA-00918: column ambiguously defined in SELECT *
  18. ORA-00984: column not allowed here [duplicate]
  19. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  20. How to resolve ORA 00936 Missing Expression Error?
  21. Oracle error : ORA-00905: Missing keyword
  22. What does SQL Select symbol || mean?
  23. How do I limit the number of rows returned by an Oracle query after ordering?
  24. SQL not a single-group group function
  25. PLS-00201 – identifier must be declared
  26. Oracle SELECT TOP 10 records
  27. issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
  28. Can a foreign key be NULL and/or duplicate?
  29. How to Select Top 100 rows in Oracle?
  30. ORA-30926: unable to get a stable set of rows in the source tables
  31. ORA-12560: TNS:protocol adaptor error
  32. PLS-00103: Encountered the symbol “CREATE”
  33. Oracle client ORA-12541: TNS:no listener
  34. SQL error “ORA-01722: invalid number”
  35. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  36. What does the following Oracle error mean: invalid column index
  37. ORA-00972 identifier is too long alias column name
  38. No more data to read from socket error
  39. What does the following Oracle error mean: invalid column index
  40. Oracle Apex column link from LOV values
  41. PLS-00103: Encountered the symbol when expecting one of the following:
  42. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  43. ORA-12899: value too large for column
  44. Oracle startup not possible – ORA-00845: MEMORY_TARGET not supported on this system – but memory size seems to be fine
  45. ORA-00918: column ambiguously defined in SELECT *
  46. Oracle date format picture ends before converting entire input string
  47. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  48. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  49. SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  50. SQL Error: ORA-00913: too many values
  51. UTL_FILE.FOPEN() procedure not accepting path for directory?
  52. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  53. ORA-01861: literal does not match format string
  54. ORA-01653: unable to extend table by in tablespace ORA-06512
  55. Is there a combination of “LIKE” and “IN” in SQL?
  56. SQL Error: ORA-01861: literal does not match format string 01861
  57. What is it exactly a BLOB in a DBMS context
  58. SQLRecoverableException: I/O Exception: Connection reset
  59. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  60. ORA-28001: The password has expired
  61. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  62. Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
  63. How do you create a temporary table in an Oracle database?
  64. Oracle “Partition By” Keyword
  65. How to insert date values into table
  66. Oracle SQL: Update a table with data from another table
  67. Oracle SQL query for Date format
  68. sqldeveloper error : no ocijdbc11 in java.library.path on windows 7
  69. How to execute an oracle stored procedure?
  70. What is the Oracle equivalent of SQL Server’s IsNull() function?
  71. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  72. Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
  73. How SID is different from Service name in Oracle tnsnames.ora
  74. ORA-01747: invalid user.table.column, table.column, or column specification
  75. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  76. SQL Queries “00904. 00000 – “%s: invalid identifier”
  77. Comparing Dates in Oracle SQL
  78. Convert timestamp to date in Oracle SQL
  79. How do I reset a sequence in Oracle?
  80. How to display databases in Oracle 11g using SQL*Plus
  81. grant select on view
  82. Update statement with inner join on Oracle
  83. MySQL equivalent of DECODE function in Oracle
  84. Hibernate dialect for Oracle Database 11g?
  85. Query to display all tablespaces in a database and datafiles
  86. ‘NOT LIKE’ in an SQL query
  87. Oracle: If Table Exists
  88. DATEDIFF function in Oracle
  89. How to create id with AUTO_INCREMENT on Oracle?
  90. LEFT function in Oracle
  91. What is the difference between Views and Materialized Views in Oracle?
  92. How can I set a custom date time format in Oracle SQL Developer?
  93. How to copy files into a virtual box oracle box
  94. How do I view the Explain Plan in Oracle Sql developer?
  95. ORA-01779: cannot modify a column which maps to a non key-preserved table
  96. ORA-01735: invalid ALTER TABLE option – Toad
  97. Find out the history of SQL queries
  98. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  99. PLS-00049 bad bind variable While using :OLD
  100. Run Oracle SQL script and exit from sqlplus.exe via command prompt

Leave a Comment

tech