Question : I’m setting up a local development environment in a virtual machine in which I installed Oracle XE among […]
Tag: oracle-xe
Set encoding from within SQL*Plus
Question : I have a large set of files with SQL commands that I run with a SQL*Plus script that […]
How to export a single schema from Oracle EE to Oracle XE?
Question : I would like to export a schema (DDL or DDL+data) from Oracle EE (Enterprise Edition) to Oracle XE […]
Restoring 40 GB Oracle backup to get db objects into Oracle 11g XE
Question : I have backup of oracle database size is almost 40 GB.This 40GB database backup contains lots of data […]
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 […]