How to Add New Line for Each Row
What is New Line Character in Oracle? Sometimes, we need to make several lines for each row. For example, we'd like to compose some dialogs… Read More »How to Add New Line for Each Row
chr(10)
Prepare Tablespace before Data Migration
In the beginning of data migration, we usually recreate some tablespaces to accommodate data from the source. The best way to do this is to… Read More »Prepare Tablespace before Data Migration
How to Migrate 9i to 12c via DB Link
Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »How to Migrate 9i to 12c via DB Link
How to Backup PL/SQL Codes in Oracle
Backup Packages and Procedures Usually, source codes of programming unit should be version-controlled by the developer team. Mostly, they use Git, CVS or SVN to… Read More »How to Backup PL/SQL Codes in Oracle
How to Resolve ORA-08102: index key not found
ORA-08102 Found some ORA-08102 errors during executions of SQL statements like this: ERROR at line 1: ORA-08102: index key not found, obj# 98830, file 69,… Read More »How to Resolve ORA-08102: index key not found
How to Identify Blocking Sessions
Here I introduce a sample of PL/SQL code to monitor the blocking sessions every N minutes and output in a formatted report. First of all,… Read More »How to Identify Blocking Sessions