Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: oracle-xe

Disable MEMORY_TARGET after being locked out of database?

By adminPosted on November 7, 2022

Question : I’m setting up a local development environment in a virtual machine in which I installed Oracle XE among […]

Set encoding from within SQL*Plus

By adminPosted on November 4, 2022

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?

By adminPosted on October 9, 2022

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

By adminPosted on September 23, 2022

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

By adminPosted on September 20, 2022

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

By adminPosted on July 16, 2022

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

By adminPosted on July 13, 2022

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

By adminPosted on May 16, 2022

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?

By adminPosted on May 9, 2022

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

By adminPosted on May 5, 2022

Question : When I asked a client for a copy of his database he sent me a .ctl file, it […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger
  • How do I get the difference in minutes from 2 timestamp columns?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding