1

Topic: Oracle Sql developer unit test

Hello.
At attempt of creation of a repository for unit test Oracle Sql developer there is an error in a command create table ut_lookup_categories
Ora-00955 The name is already involved for existing object
For what tries to create the table if it already is? And how to bypass or rectify an error? After renaming does not help as the name is used also restrictions.

2

Re: Oracle Sql developer unit test

wwee12 wrote:

For what tries to create the table if it already is?

wwee12 wrote:

At attempt of creation of a repository for unit test

That comes to the first mind that you try to create  which already is... Or it, but nedorozhdennyj/nedoubityj from last attempts...

3

Re: Oracle Sql developer unit test

At attempt  repository A repository must exist in the local schema

4

Re: Oracle Sql developer unit test

Likely then not  and how it it is possible ?

5

Re: Oracle Sql developer unit test

https://docs.oracle.com/cd/E15846_01/doc.21/e15222/unit_testing.htm#BCGBIFGA wrote:

A repository can be unshared or shared ;
When a repository is made shared, SQL Developer creates public synonyms for the appropriate repository objects

.
Check up

select owner, object_name, object_type from dba_objects
where object_name = ' UT_LOOKUP_CATEGORIES'

6

Re: Oracle Sql developer unit test

Yes such table already is available for me, but as wrote above its renaming does not help. Also tried "Deselect As Shared Repository ' - the local schema must contain a shared repository.

7

Re: Oracle Sql developer unit test

wwee12 wrote:

Yes such table already is available for me, but as wrote above its renaming does not help.

And what for to rename? If in a DB something hinders me or it is not clear, I always it something .

8

Re: Oracle Sql developer unit test

AmKad wrote:

something hinders me or it is not clear, I always it something .

it can be sick of Dropat.

9

Re: Oracle Sql developer unit test

the dancer. wrote:

it can be sick of Dropat.

Yes, forgot to tell. If suddenly I can not delete object because of lock at first I kill locking session.

10

Re: Oracle Sql developer unit test

AmKad, you have a ready mechanism in a patch which before object removal, fulfills search of sessions of disablers and the automatic machine they are killed?
And I remember that, you Likvibejzo-dependent.

11

Re: Oracle Sql developer unit test

merch wrote:

and the automatic machine them kills?

Session or disablers?

12

Re: Oracle Sql developer unit test

Created the new user at it a repository formed without errors. Thanks.

13

Re: Oracle Sql developer unit test

merch wrote:

AmKad, you have a ready mechanism in a patch which before object removal, fulfills search of sessions of disablers and the automatic machine they are killed?
And I remember that, you Likvibejzo-dependent.

Yes, shutdown abort.