ORA-02180: invalid option for CREATE TABLESPACE



ORA-02180: invalid option for CREATE TABLESPACE..

Answer / guest

Cause: An invalid option appeared.

Action: Specify one of the valid options: DATAFILE, DEFAULT
STORAGE, ONLINE, OFFLINE, FORCE, RETENTION.

Please add more information about this Error

Is This Answer Correct ?    12 Yes 14 No

Post New Answer

More Oracle Errors Interview Questions

LFI-00117: Unable to rename file.

1 Answers  


ORA-19660: some files in the backup set could not be verified

1 Answers  


ORA-39003: unable to get count of total workers alive

1 Answers  


IMP-00016: required character set conversion (type number to number) not supported

1 Answers  


ORA-23347: datatype string for column string table string not supported

1 Answers  






ORA-19764: database id string does not match database id string in control file

1 Answers  


ORA-14456: cannot rebuild index on a temporary table

1 Answers  


ORA-07550: sftopn: $CONNECT failure

1 Answers  


TNS-00299: Response from Navigator: string

1 Answers  


ORA-07412: sfaslv: Error getting entry in asynchronous write array.

1 Answers  


ORA-08261: ora_addr: cannot find name in nameserver

1 Answers  


How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

0 Answers  


Categories