## SQLWays Troubleshooting Guide

#### Oracle Database

This chapter presents troubleshooting tips for Oracle databases. This section also describes how to deal with some frequently encountered problems with the SQL Loader and SQL Plus utilities. These tools are used by SQLWays to import databases to Oracle.

- Oracle SQL Loader does not terminate
- DROP TABLE Errors, ORA-02449: unique/primary keys in table referenced by foreign keys

#### Oracle SQL Loader does not terminate

Software

Windows 2000, Oracle client 8.0.5 (8.0.x).

Symptoms

- When data is imported SQLLoader does not return to the command prompt, so the user have to press Ctrl+C before he/she can start the next job.
- When SQL Loader is called from other applications, its window stays open.

Action

To solve the problem you need to upgrade your client to Oracle 8i (8.1.x). Oracle 8.0.x is not certified for Windows 2000 and unexpected things can happen. This might be one of them.

#### DROP TABLE Errors, ORA-02449: unique/primary keys in table referenced by foreign keys

When SQLWays executes the DROP TABLE statements before creating tables, Oracle may return the error ORA-02449. This means that the table cannot be dropped because it is referenced by a FOREIGN KEY constraint.

To drop tables referenced by child tables, you can the CASCADE CONSTRAINTS option in the DROP TABLE statement. For more information, see Dropping Tables.

To generate the CASCADE CONSTRAINTS option for Oracle

- SQLWays Wizard - DDL Options Page
- SQLWays command prompt - [DDL] Section

[Main] [Table of Contents]
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.