SQL & PL/SQL :: Merger Of Sequences
Feb 10, 2012
I have something upcoming task which include a merger of two database instances. The schema structure is exactly same and there is no duplicity problem. I want to dump the both schema data in one instance. The only challenge i have here is "How to manage the sequences?".
Explanation: Instance A.
Sequence : 1,2,3,4,....20
Instance B
Sequence: 1,2,3,4....20
Requirement : when i merge it should be
Instance C: 1,2,3,4...20 [from Instance A ] cont.. 21,22,23,24.....40 [From Instance B]
View 1 Replies
Feb 14, 2011
We have a requirement to install a new application into a 2 node RAC database.
Going over the installation scripts, I noticed that there is a requirement to use sequences, which immediately set the alarms ringing - I know that using sequences with RAC may cause issues (esp as the script is set to cache 500 values at a time).
The way we are planning to implement this application is by channeling the application through a service that is preferred on one node. The second node will be set to available for the service. The database will ONLY be used for this application.
Will this be enough to get round this situation? Or will the second node still try and cache sequence numbers?
View 2 Replies
View Related
Apr 6, 2012
I have created a Sequence called testseq. Its working fine since last 1 week. Suddenly no one sequences will not create nextvalue. after executing nextval its return null row.
View 2 Replies
View Related
Apr 17, 2013
I am having a table with out a primary key .It also contains data.
My requirement is to add a new column to the table and update the column value with unique and sequential number , starting from 1 to end of rows.
This has to be done without using a sequence.
View 2 Replies
View Related
Dec 20, 2010
i had a requirement to generate unique numbers without sequences.
For Example: i had a table called "Test".Test has two columns.
ID and Name are 2 column names.Primary key constraint exists on column(ID).
How to generate the ID values without using sequence and Stored procedures.
View 9 Replies
View Related
Feb 4, 2013
I have a temp table and want to insert that data into 2 tables. In both of my tables i have a sequence column but in my second table its a foreign key to the main table
up_query="INSERT INTO AFFILIATE (FNAME,LNAME,EMAIL,PHONE,ORG,ADDRESS1,ADDRESS2,COUNTY_ID,AFF_ID)
Select a.FNAME, a.LNAME,a.EMAIL,a.PHONE, a.ORG, a.ADDRESS1, a.ADDRESS2,C.COUNTY_ID,'AF'||aff_seq.nextval
FROM temp_aff A LEFT OUTER JOIN COUNTY C
ON UPPER(A.COUNTY)=C.CNAME";
$up_query2= "INSERT INTO TEST4 (DEPT_ID,CAMP_ID,AFF_ID, PASSWD)
SELECT D.DEPT_ID,C.CAMP_ID,aff_seq.currval,'Zq'||dbms_random.string('A',4)||'$8' from dual,TEMP_AFF A
left outer join DEPT D ON (UPPER(A.DEPT)=UPPER(D.DNAME))
left outer join CAMPUS C ON (UPPER(A.CAMPUS)=UPPER(C.CPNAME))";
However in my test4 table its inserting the aff_seq.currval for all records. Its not incrementing as in the affiliate table.
View 1 Replies
View Related
Apr 17, 2013
i am having a table with out pk along with data.
Now , i need to add one column to that table , and update this column with the sequence no
like 1,2,3...... upto the max no of records. but i have to do this with out using a sequence.
how can i do.
View 1 Replies
View Related