ORA-02196: PERMANENT/TEMPORARY option already specified

Question Posted / guest

1 Answers
2937 Views
I also Faced
E-Mail Answers

ORA-02196: PERMANENT/TEMPORARY option already specified..

Answer / guest

Cause: In CREATE TABLESPACE, the PERMANENT and/or TEMPORARY
options were specified more than once.

Action: none

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00001: unique constraint (string.string) violated

1 Answers

ORA-12533: TNS:illegal ADDRESS parameters

1 Answers

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

0 Answers HCL,

ORA-32409: materialized view log on "string"."string" already excludes new values

1 Answers

LSX-00291: value "~1S" is less than minimum "~2S" (~3S)

1 Answers

ORA-12013: updatable materialized views must be simple enough to do fast refresh

1 Answers

ORA-27084: unable to get/set file status flags

1 Answers

ORA-16776: Health check of the log transport service failed.

1 Answers

ORA-13185: failed to generate initial HHCODE