Question : I have backup of oracle database size is almost 40 GB.This 40GB database backup contains lots of data […]
Tag: oracle-xe
ORA-01033: ORACLE initialization or shutdown in progress using Oracle Express
Question : I am using Oracle Database 11g Express Edition. I’m on Windows 7-64Bit I get this error when trying […]
quick checkpoints for development mode
Question : i’m a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database […]
ORA 01031 Insufficient privileges on GRANT SELECT on ALL_CATALOG to a user as system user
Question : Command: GRANT SELECT ON ALL_CATALOG TO appdbuser * Error: ERROR at line 1: ORA-01031: insufficient privileges PROBLEM: I […]
migration of oracle xe 10 to xe 11 fails with wrong paths used in the import
Question : I’m following the documentation to upgrade an OracleXE 10.2 database to OracleXE 11.2. The export succeeded without any […]
Oracle 10XE: Stop schemas seeing the all_users table?
Question : I’ve got an Oracle 10g XE Database that I want clients to be able to view remotely via […]
Access oracle database from control file
Question : When I asked a client for a copy of his database he sent me a .ctl file, it […]
Which backup files are needed for a successful restore?
Question : Considering the built-in ‘Backup Database’ script (backup.bat) that comes with a new installation of the Oracle Express 11g […]
ORA-01017 Invalid Username/Password in SQL Developer
Question : I installed Oracle 18c XE and SQL Developer 18.4, both are the latest. Logged in with SYSTEM and […]
Migration from MySQL to Oracle generates empty tables
Question : I’m using SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is […]