ORA-02190: keyword TABLES expected

Cause : The keyowrd TABLSE is expceted fololwing DRPO CLUSTE R NICLUDING.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts


update : 16-08-2017

ORA-02190 - keyword TABLES expected
ORA-02190 - keyword TABLES expected

  • ora-30334 : illegal dimension level name
  • ora-08332 : rollback segment #string specified not available
  • ora-25316 : Late in the current transaction to begin an Enqueue/Dequeue operation
  • ora-02051 : another session in same transaction failed
  • ora-01338 : Other process is attached to LogMiner session
  • ora-37181 : expected exactly string columns for dimension string, got string
  • ora-24089 : AQ Agent string already exists
  • ora-30507 : normal triggers cannot be based on a schema or a database
  • ora-15031 : disk specification 'string' matches no disks
  • ora-38740 : Usable blocks value string is not valid.
  • ora-39140 : dump file "string" belongs to job string
  • ora-39202 : Data cannot be filtered or selected in string jobs.
  • ora-06125 : NETTCP: ORASRV exited unexpectedly
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-12350 : database link being dropped is still mounted
  • ora-09877 : sstascre: shmget error, unable to get a shared memory segment.
  • ora-28592 : agent control utility: agent SID not set
  • ora-09261 : spdcr: error creating detached (background) process
  • ora-28108 : circular security policies detected
  • ora-39773 : parse of metadata stream failed
  • ora-07259 : spdcr: exec error, detached process failed in startup.
  • ora-38102 : Invalid column in the INSERT WHERE Clause: string
  • ora-29259 : end-of-input reached
  • ora-16650 : command incompatible when Fast-Start Failover is enabled
  • ora-32579 : password for SYSTEM already specified
  • ora-13011 : value is out of range
  • ora-21710 : argument is expecting a valid memory address of an object
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.