That's why it's better to look up the schema ids and field ids in your workflow based on the form/field names, then use var substitution in your direct sql (e.g. select C$fieldid1$ from T$schemaid1$ where C$fieldid2$ = '<some literal value or field>').
Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: > ** > > Axton: > > Definitely the way to copy a tablespace from one server to another. I > had forgotten about copying the LOB space, too. I tend to use > Export/Import from Remedy rather than do this at the DB level. However, > this does not scale well if you are working with Direct SQL and > reference tables by name. > > James McKenzie > L-3 GSI > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams > Sent: Friday, September 01, 2006 12:53 PM > To: arslist@ARSLIST.ORG > Subject: Re: Setup Dev Server > > I duplicate databases infrequently. The metadata (actlink_open, email > mailbox, etc.) are fairly easy to clean with pl/sql. Copying between > different tablespaces is a little tricky due to LOB storage, but not > impossible. You have to manually create the tables with modified DDL > (specifying lob storage) that have LOBs prior to running the imp of the > dmp file to ensure the LOBS go to the right tablespace during import. > > http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:378418239571#16075038165527 > > > The main reason we do it this way is because this method puts the margin > for error/reliability and the time required to complete are in our favor. > > Axton Grams > > McKenzie, James J C-E LCMC HQISEC/L3 wrote: >> ** >> Fred: >> >> (Wacking self on head). Thanks. >> >> Now the next question is how did they duplicate the database? There >> are variables in the Remedy metadata that will error out if they did a >> physical vice ARExport/ARImport move of data. This may be causing the >> problem. I tried a physical move from one tablespace to another on >> the same server and Oracle would not let me. >> >> James Mckenzie >> L-3 GSI >> >> ---------------------------------------------------------------------- >> -- >> *From:* Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W >> *Sent:* Friday, September 01, 2006 12:12 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Setup Dev Server >> >> ** >> He said they were on 2 different servers >> >> ---------------------------------------------------------------------- >> -- >> *From:* Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC >> HQISEC/L3 >> *Sent:* Friday, September 01, 2006 1:41 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Setup Dev Server >> >> ** >> >> Fred: >> >> I think the problem may be that the production and dev servers are >> pointing to the same Oracle DB Instance and that they are installed in >> two different tablespaces. This can lead to disaster of major > proportions. >> >> Solution: >> >> Have DBA create a second instance on the Oracle DB for development. >> Or install Oracle on a second server (this is LEGAL per Oracle.) >> >> James McKenzie >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W >> Sent: Friday, September 01, 2006 11:17 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: Setup Dev Server >> >> Do you have the environment variables set up correctly? >> >> The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle >> 9iR2 client. >> ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. >> ORACLE_SID and TWO_TASK set for your dev database. >> TNS_ADMIN pointing to your tnsnames.ora file. >> >> Fred >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley >> Sent: Friday, September 01, 2006 10:31 AM >> To: arslist@ARSLIST.ORG >> Subject: Setup Dev Server >> >> Hi List: First time emailer. Long time reader. >> >> I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having >> errors upgrading an existing DB. >> We took a copy of production DB, and placed it on a different oracle >> Server. Oracle 9.2.0.4.0 64bit. >> My tnsnames is set correctly to Dev Server and connection to remedb >> listener. >> The name of the DB is the same for Production and Dev. Which is OK. >> They are on different servers. >> When I'm setting up the Dev server running server.exe, Its asks for >> SID name and what type of install. Upgrade, Overwrite or Shared. I >> select Upgrade because the DB out there is an exact copy of the >> Production having all the Data - I want the data in tact just to > install the Server. >> >> Here is the Error >> 15:40:39 An error was encountered during the upgrade of the AR System >> database. >> 15:40:39 Installation terminating ... Original database server is >> intact and accessible >> 15:40:39 Resolve the problem that causes the error (contact Technical >> Support, if necessary) 15:40:40 ****->[ShowMsg]: Setup is rolling back >> directories.... >> >> 15:40:40 Setup is rolling back the directories. >> 15:40:41 ServiceName not found. Using Default: Remedy Action Request >> System Server >> 15:40:41 ****->[ERROR]: AR System Database upgrade error. The original >> database is intact and accessible. >> >> Anyboby have something similar. Or suggestion. >> >> John Kelley >> Help Desk Analyst >> 130 Royall Street >> Canton, MA 02021 >> Mail Center 1W >> 781-737-3564 >> >> ______________________________________________________________________ >> _________ >> >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> >> __20060125_______________________This posting was submitted with HTML >> in it___ __20060125_______________________This posting was submitted >> with HTML in it___ __20060125_______________________This posting was >> submitted with HTML in it___ > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > __20060125_______________________This posting was submitted with HTML in > it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org