hi am having this error when inserting data i did this
QL> ALTER SYSTEM SET RECYCLEBIN= OFF DEFERRED;
SQL> purge recyclebin;
SQL> show parameter recyclebin
SQL> connect sys /as sysdba
Enter password:
Connected.
SQL> ALTER SYSTEM SET RECYCLEBIN= OFF DEFERRED;
System altered.
SQL> comit;
SP2-0042: unknown command "comit" - rest of line ignored.
SQL> commit;
Commit complete.
SQL> purge recyclebin;
Recyclebin purged.
SQL> commit;
Commit complete.
SQL> show parameter recyclebin;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recyclebin string on
SQL>
SQL> ALTER SYSTEM SET recyclebin = OFF scope=BOTH;
ALTER SYSTEM SET recyclebin = OFF scope=BOTH
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option
show parameter log_file_name_convert;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert string
am in oracle database 18c