Tablespace Deletion Error:
ERROR at line 1:
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: '/data/oracle/oradata/xe/admindb01.dbf'
ORA-01203: wrong incarnation of …
How to Create a Read-Only User in Oracle
create user reader identified by reader123456;
grant connect,resource to reader;
grant select on AD_TEST to reader; #Use a PL/SQL tool to log in as the relevant user and grant the AD_TEST table to reader …
Scenario: After downgrading system memory configuration, Oracle fails to restart and throws an error upon startup. The system initially had a larger memory allocation, which was reduced midway. After completing the downgrade, the database cannot start normally and reports the following error:
or
ORA-00845: MEMORY_TARGET not supported on this system… Possible cause: ORACLE MEMORY_TA …
How to Enable Archivelog Mode Settings:
SQL> archive log list; #Check if archivelog mode is available
The archive destination USE_DB_RECOVERY_FILE_DEST defaults to the flash recovery area ($ORACLE_BASE/flash_recovery_area). You can view the flash recovery area info with the following SQL …
When using the EXP tool for backup export or data migration, you may sometimes encounter numerous “EXP-00091: Exporting questionable statistics” errors.
How to Fix:
Set the Linux system’s NLS_LANG environment variable to the database’s character set
1) Query the database’s …
MySQL Create User Error:
#1805 – Column count of mysql.user is wrong. Expected 43, found 42. The table is probably corrupted
Cause:
The database structure was not upgraded with mysql_upgrade after upgrading MySQL.
Solution:
fin …
Error Installing Oracle Client:
sqlplus64: error while loading shared libraries: libsqlplus.so …
The cause is that the relevant files were not found.
Fix: Locate the extracted instantclient_11_2 folder and copy the .so files inside to /lib:
cp …
Oracle Connection Error: Cannot Allocate Memory Fix
Clipping path king is one of the best graphics design provided company.clipping path and photo masking services are provided here. High skilled graphic designer team is providing their service …
Sometimes a table contains many empty rows that you may want to delete, or you need to delete all rows where a certain field equals a specific value. You can use the following command.
Command:
delete from tabl where `codes` = ''; # Delete rows in the tabl table where the codes field is empty …
