Thank you very much Pilgrim. I made a DB link successfully and its now working. :-)
Jam
jam26
Last Activity: Nov 26 '08, 07:10 AM
Joined: Nov 13 '08
Location:
-
Hello Experts,
Now that I have connected the sequence across all schemas, Is it possible that I connect my other database on this sequence using trigger?
Thanks,
JamLeave a comment:
-
Hello Experts,
I already made to link all my schemas to the sequence using Trigger. This may not be possible without your help.
Thank You Very Much!!!!
JamLeave a comment:
-
Ok I will check this. Is it true that the trigger is risky to use?
Thanks.Leave a comment:
-
Wow! does it mean if I have 15 schemas, it will be 15 tables? Can you teach me how to do that please.
Thanks.Leave a comment:
-
My objective is to have a number series across all 15 schemas. If I let the autokey generates the number it will also generates 15 same numbers.
I think Pilgirm is right, I need to link all the schemas to the sequence I made but my problem is how the sequence automatically increment once I link all these schemas on it.
Thanks.Leave a comment:
-
Well what happened here is there's an original autokey generated by our application per schema. What I did is I changed the autokey of application to the sequence I created.
I used this script to change the autokey of application to the sequence.
update C08ML03B.autoke y
set seed = D06SP04D.equip. nextval
where tbname ='ASSETS'
The D06SP04D is the original schema where I created the sequence....Leave a comment:
-
Sorry Pilgrim. But what do you mean by code?Leave a comment:
-
Yes. we are using Oracle on the Maximo Application.Leave a comment:
-
I am using Maximo Application. I have multiple schemas on the application and I need to connect those schemas in only one number series. I f I use the sequence generated by the application, it will possibly generates a same number when I connected into other schemas. The directive is to have only one number series in all schemas that's why I created a sequence.
Thanks.Leave a comment:
-
I used only this script to connect the application on the sequence.
update C08ML03B.autoke y
set seed =D06SP04D.equip .nextval
where tbname ='ASSETS'
What happend is, at first the system will look into the last number generated by the sequence. For example the last number is 10 then the system generates 11 for new number. Then when I connect to other schema, the system will also gives 11 as the new number...Leave a comment:
-
Actually it gives different numbers. But if I connect this sequence in our Maintenance Application (Maximo), It doesn't work in other schema which I linked on this sequence. I expected that before they generate a number, the schema will look first on the last number generated on the sequence.
Thanks.Leave a comment:
-
Hi,
I made it this way: I created this sequence in Schema D06SP04D
In creating Sequence:
CREATE SEQUENCE equip
START WITH 70000
INCREMENT BY 1
NOCACHE
NOCYCLE;
Then I link this to other schema like C08ML03B
update C08ML03B.autoke y
set seed =D06SP04D.equip .nextval
where tbname ='ASSETS'
Is there anything wrong...Leave a comment:
-
Hi Pilgrim,
I already grant a priveleges in other schema. But when I tried to do the sequnce, the system generates the same number in all schema. The sequence number generated in Schema 1 also the same number generated in Schema 2. How does it happen? Is there any procedure that I missed?
Thanks.Leave a comment:
-
Thanks for this. I already created a sequence. Just one more question, How can I connect this sequence on multiple schemas? That all my schemas will look on the last number sequnce before they generate the next number.Leave a comment:
-
Can you teach me on how to do that or if you have some documentation with regards onto this, can you please send it to my email addressLeave a comment:
-
Well there's a directives from management for the new equipments to have a number series that can be generated everytime they encoded it on the system across all 15 schemas. For Example, I encoded in Schema 1 with 00001 number series and then if I encoded again Schema 2, the system must give a 00002 number. How can I do that?Leave a comment:
-
Thanks for Answering my concern. Can you teach me how to do that?...Leave a comment:
-
Linking of Schemas
Hello,
Is there anybody can help me on how can I make an auto number across all my 15 schemas. I need to create it for tagging of my equipment.
Thanks,
Jam
No activity results to display
Leave a comment: