Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Installing Unit Test repository

Cliff MackApr 25 2014

Ver 4.0.1.14

Build MAIN-14.48

Windows 7 64bit

Oracle 11.2.0.1 EE (same box)

Getting an error when installing the unit repository that leaves SQLDev in a state where you can neither use it or delete (I wound up just dropping the UT_% tables).

After the 2 roles are created, grants given, and synonym created, it must go into a DDL script which is where I get the error popup:

Error occured whilst processing script: SQLException  (misspelling Oracle's not mine     ).

This leaves my Unit Test view window (left pane) as:

Unit Tests - TESTDB (Admin) (User)

  -- Not connected to a repository

When I click on Tools ==> Unit Test ==> Deselect Current Repository

it works

but when trying to re-connect I get:

No Repository was found on the selected connection.

Would you like to create one now?

Yes   No

Of course, I select Yes

Which is when I get

Error occured whilst processing script:

Error starting at line: 9 in command -

CREATE TABLE "UT_LOOKUP_CATEGORIES"

you get the idea.... I'm stuck in this loop where I can't use it or really delete or recreate it which leads me to drop the tables and try again

..... which isn't working either.

Thanks,

Cliff

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 23 2014
Added on Apr 25 2014
0 comments
848 views