Ha I didn't even have a backup of this database - but then again primarily because it wasn't important. What I had done was installed a brand new instance of ARS on a brand new machihne to replicate another system.. so basically it had kind of a similar database structure.. then restored the other datatbase on a different schema than ARAdmin called ITSMUser in the same tablespace ARSystem, but the restore didn't work as it didn't import the tables but it did import the views but obviously the views were not valid, as the tables were missing. The script I generated to drop the views owned by ITSMUser, was run when logged in SQLPlus as ARAdmin :-) That was my oooops moment :-)..
My next attempt on restoring the other database worked so I didn't need the ARAdmin schema anyways, which I dropped later in the afternoon.. Joe ________________________________ From: "Meyer, Jennifer L" <jennifer.me...@its.nc.gov> To: arslist@ARSLIST.ORG Sent: Thursday, July 23, 2009 9:15:35 AM Subject: Re: What's the difference between a Remedy Administrator and a Remedy Developer? ** Had it not been a database you wanted to remove, it would have been an excellent opportunity to practice your database restore skills! Jennifer Meyer ________________________________ From:Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of Joe DeSouza Sent: Wednesday, July 22, 2009 6:44 PM To: arslist@ARSLIST.ORG Subject: Re: What's the difference between a Remedy Administrator and a Remedy Developer? Or run a script to drop tables or views in the wrong schema :-) I did that yesterday and fortunately it was a database we needed to blow away anyways so I could actually smile at what I did :-) Joe ________________________________ From:"Grooms, Frederick W" <frederick.w.gro...@xo.com> To: arslist@ARSLIST.ORG Sent: Wednesday, July 22, 2009 6:24:35 PM Subject: Re: What's the difference between a Remedy Administrator and a Remedy Developer? Don't forget to watch out for an Admin who does "rm -rf *" from the root of a server. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Wednesday, July 22, 2009 4:38 PM To: arslist@ARSLIST.ORG Subject: Re: What's the difference between a Remedy Administrator and a Remedy Developer? Actually I see things in the reverse of how you stated them as well. Having worked professionally doing system administration work as well as software development (including but not limited to ARS) I see system administrators and DBAs being more easily replaceable than software developers. Sure, developers may not always have root/Administrator access, but their job is much more complex than performing administration duties. You can also look at it from the amount of damage a person can do. If you are an incompetent system administrator, your system might run slowly or even crash and have to be replaced. If you are an incompetent developer, your bad code could affect a company for the five years or so that your app is used, and even beyond if the data is migrated into the application that replaces yours. Of course, a good system administrator is capable of doing some coding, and a good developer is knowledgeable of hardware, DB, and OS limitations. You can't master either role if you stay within strict confines of your job description. Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, July 22, 2009 3:49 PM To: arslist@ARSLIST.ORG Subject: Re: What's the difference between a Remedy Administrator and a Remedy Developer? So would it be accurate to understand from the majority of your responses that in Remedy, the terms "administrator" and "developer" are bass-ackward from the rest of the IT world in that a Remedy administrator handles data configuration in the user tool, whereas a Remedy developer is responsible for application performance, maintenance, and improvements? As I understand the rest of the IT world, Administrators have Root, and therefore god-like powers, whereas developers are just a bunch of code-monkeys who will be replaced by a fresh college graduate the moment management deems their salaries are too high. If my summary above is correct, there are a lot of hiring managers out there that are confused. Since my job duties have always included everything from server build and application installation to user training and my title has always been "Remedy Administrator" Jr, Sr, Consultant, etc..., I think we need a better system. Jennifer Meyer _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"