| Clinicals [message #102427] |
Thu, 30 May 2002 13:23  |
sandhya
Messages: 15
Registered: February 2002
|
Junior Member |
|
|
Hello Orafaq,
While i was going through the Dice.com site i happen to see the requirement for oracle clinicals.I have browsed through the internet immensely to find out what is this oracle clinicals but i could not get the information about it and if there is anything like that i want to know and learn more about it.
Please help me find what it ia and how to learn
Hope answer for my request is met quickly.
thank you
bye
sandhya
|
|
|
|
| Re: Clinicals [message #102497 is a reply to message #102427] |
Thu, 27 June 2002 07:40  |
Syed Sabdar Hussain
Messages: 4
Registered: June 2002
|
Junior Member |
|
|
PURPOSE
-------
Understanding of and maintainance of sequences for Oracle Clinical.
SCOPE & APPLICATION
-------------------
Functional Clinicals, DBA, Applications Developer
Sequences for Oracle Clinical
-----------------------------
Rules for regenerating sequence numbers:
****************************************
Patch# 738866 (for RDBMS 7.3.3.6 only):
ORACLE NUMBERS >= 100000000 CANNOT BE QUERIED FROM A CALLOUT.
This patch must be installed if Sequence numbers will approach 100000000.
The increment size required for all OC tables except responses must be
100.
For responses, it must be 2000.
If you run out of id's for a particular sequence, you can start the sequence
over with a different 'seed' value - as long as that seed is not and will
never be used by another database that replicates with the current database.
The seed is the number, from 01 to 99, that is in the lowest two places of
the id.
If the sequence was originally started with a min value of 1 and increment
by value of 2000, you should have entries for 1, 2001, 4001, 6001 and so on.
You may drop the sequence and recreate it starting from 10 with the same
increment (10, 2010, 4010) with no problem, provided there are no
inconsistencies on slave sites (ie sequences must be in sync accross all).
Make sure that when dropping/recreating the sequence the minimum value
starts higher than the last minimum value used.
Using sqlplus to verify seed and sequence:
******************************************
To see the start seed number:
SQL> select ocl.dbseed from dual;
DBSEED
----------
3
To see the increment value:
SQL> select INCREMENT_BY from all_sequences
2 where sequence_name = 'RESPONSE_SEQ';
INCREMENT_BY
------------
10
To verify that the system is incrementing correcty:
SQL> select response_seq.nextval from dual;
NEXTVAL
----------
174493
SQL> /
NEXTVAL
----------
174503
The system start seed number is 3 and is incremented by 10.
RELATED DOCUMENTS
----------------
.
For further info contact me..Bye sabdar
|
|
|
|
| Re: Clinicals [message #102629 is a reply to message #102427] |
Sat, 03 August 2002 00:58 |
rajesh
Messages: 173
Registered: November 1998
|
Senior Member |
|
|
Hi there,
Did any one install oracle clinical version 4.0? If so please let me know, I'm stuck in the middle of installation. I have one or two questions to ask.
I appreciate it very much if some one replies to my question.
Thank you,
Rajesh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
