Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01795, limit on in clause

405508Mar 15 2004 — edited Mar 13 2012
hi guys,

I have the following query,

Select
shogen_no,
shogen_desc,
disp_turn
From
shogen
where
shogen_no in ('one', 'two', 'three', ..........'more than thousand')

When I try to run it, the ORACLE (8.1.6) gives me following error:
ORA-01795 maximum number of expressions in a list is 1000

Can anyone explain the situation?
1) Cant we put more than 1000 values in 'in clause'.
2) What is the other way of doing it.

I am running this query in a PL/SQL procedure. First of all I gather the values and put them in a varchar2 (shogenList). Then I put that variable in the 'in clause' i.e. where shogen_no in ('||shogenList||')..

Thanx for any help
Omer

Comments

amann-Oracle

Answers Inline :

1. Delete the orphan VM.

>>>> Try to move the Guest VM from Unassigned Virtual Machines to any running hypervisior and then try to delete the Guest VM. If the same fails try it from OVMCLI. Can you post the error message when you try to delete it from OVMCLI

2. Make the  new VM created from the virtual appliance available for use.

>>>> I suppose you can find it by selecting server pool (not servers) => Choose Perspective as Virtual Machine. If you still fail to find it, try to start Guest VM using xm commands :

                # xm create vm.cfg

                        vm.cfg location : /OVS/Repositories/xxxx/VirtualMachines/xxxx/vm.cfg

         

        After which you would be able to see that under any of the server. If you wish to start it on a particular server. Migrate it to that host. Edit Guest VM Window => Change Start Policy to Current Server

1 person found this helpful
dave carvalho

Thank you so much for the reply!

2. Worked perfectly, thank you!

As for 1.

Vm is also not listed in CLI.

When trying to move it to a server, I get:

GEN_000002:No object of type Vm with id null(0004fb00000600007494b4ba7374c2cb), is currently in the db.

amann-Oracle
Answer

Seems Oracle VM Manager is not synchronized with the internal DB. Can you try below and let me know if it helps :

1. Touch a file called "/tmp/.resyncUI" as the oracle user:

             # su - oracle

             # touch /tmp/.resyncUI

      If the file cannot be touched as the oracle user, just change the privileges to allow anyone to delete it, so that the manager can delete it after doing a re-sync:

2.          # touch /tmp/.resyncU

             # chmod 666 /tmp/.resyncUI

3.   Re-start the manager service

           # service ovmm restart

Marked as Answer by dave carvalho · Sep 27 2020
2 people found this helpful
dave carvalho

Awesome!

Didn't know this .resyncUI trick, but it worked fine!

Thank you so much, you solved both my problems.

Kind regards

David

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 14 2023
Added on Mar 15 2004
12 comments
240,420 views