Problem solve
Get help with specific problems with your technologies, process and projects.
Problem solve
Get help with specific problems with your technologies, process and projects.
LOB tables missing with exp/imp move of schema
I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing. Continue Reading
How to estimate your data deduplication ratio
This tip details the factors that influence data deduplication ratio (the ratio of data before deduplication to the amount of data after deduplication), so you can estimate the data deduplication ratio you can reasonably expect to achieve. Continue Reading
How to increase SGA_MAX_SIZE in Oracle
How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup. Continue Reading
-
Employees with the same first and last names in SQL
How do I SELECT a list of employees who have the same last and first name in SQL? Continue Reading
When will support for Oracle 9i be discontinued?
When will general support for Oracle 9i be discontinued? Continue Reading
Sorting a clob column
I'm trying to sort a column type asc as well as desc. I'm able to sort the clob column desc but not able to sort it asc. Can you please help me out?Continue Reading
Oracle vs. Sybase: 10 reasons to use Sybase on Linux
Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle.Continue Reading
ON DELETE RESTRICT
I would like to know where we use DELETE RESTRICT?Continue Reading
Multiple instances on a single database
Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)?Continue Reading
What is the difference between DB2 UDB and DB2 OS/390?
Database expert Craig Mullins explains the differences between DB2 UDB and DB2 OS/390. He begins by clarifying that the two are comprised of completely different code bases.Continue Reading
-
Purpose of roll forward and roll backward
What are rolling forward and rolling backward in backup and recovery?Continue Reading
ORA-12801 and ORA-01652 errors on running query
PL/SQL to display all tables
Merging datasets with NULL values
A MERGE may appear to work properly, but it's important you check your target dataset to make sure it does. This tip explains why and how.Continue Reading
Telling EXECUTE IMMEDIATE to commit
How to validate zip code, city, and state code
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
COALESCE on three columns
Age constraint on a date column
Getting a row number in a group
Checking if row is locked before using it in a procedure
Assignment operators explained