Search results for query: *

sorry, just sent it!

lewisp gets a star! Thanks so much, your example gets me exactly what I needed...I started to create a copy of the table, created a sequence on it and then did an insert/select with a trigger on it, but it was taking too long. Thanks again kind sir!

Hi - Need to write a pl/sql block that can quickly insert 10,000 rows in a column. Right now, the column is blank. (example: table.column row 1 in column is 1 row 2 in column is 2 row 3 in column is 3 ... and so forth.. how would a PL/SQL block be used with a counter to do this?

for the purposes of this post, I think that the RDBMS is irrelevant..the MF20.dsn point to the Oracle drive and the SERVICE_NAME. I did change the MF20.dsn as shown above, but I tried to log into the CMC on this server, but it couldnt connect... I like your reply though, I'll double check the...

Scott - good point, but I want to make sure I clarify my environment..Alls I want to do is change the MF20.dsn file to point to the new data store...No ODBC is needed here.. Please see the listing below...Should I need to do a DSMAINT MIGRATE to achieve this? the guide didnt get this specific...

my original Farm data store is in an Oracle 7.x database..Here is what I did: * exported the Oracle 7 database * imported it into a new Oracle 9 schema within an instance(no errors..) * kept the same schema names for the data store.. Now, how do I point one of the servers within the farm to the...

Let me further my question... I see the dsn reference in the registry, if I want the data store to point to my newly migrated oracle copy of the data store, would it be as simple as changing the contents of that file to point to the new database. or would a dsmaint config still need to be done?

okay smart guy..you get a coke! Well done, the IMA service is now connected..One more thing..I didn't think that the IMA service had to be the MF20.dsn...Does it? What gave it away that I was playing with the Resource Manager? you get a big fat star!! much apprciated!

thanks for the reply...no luck though..picture this from a cmd prompt...this is how it is typed in: C:>DSMAINT CONFIG /user:CTX_RM /pwd:ctx /dsn:"C:\Program Files\Common Files\ODBC\Data Sources"\rmsummarydatabase.dsn running the above says that the data store connected successfully, but the...

IMA_DB_RESULT_TABLE_NOT_FOUND. Citrix help sucks! Hoping for better help here! I have a DSN pointing to my oracle data store, I did a DSMAINT CONFIG /user:CTX_RM /pwd:ctx /dsn:citrix.dsn The current directory is the c:\program files\common files\odbc\data sources so I didn't type the full...