Cool.. What I did recently was wrote a MS-DOS batch file that created a .sql file, which basically created the necessary .par files to export a production dump of the ARSystem database, to a test database minus all the production application data. I used the command line ability of calling the SQLPlus client to run that sql file to create the necessary .par files and then again the command line ability to exp and imp the data from production to test. The par files were created by spooling results to a .par file..
I still need to work on a couple of things to make that bat file work perfectly, but for the most part I was able to replicate the production ITSP database to a test environment by completely skipping the incident, change, problem and asset data.. I wasn't sure if you could use Toad from the command line to do things like that.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client ** Yes And since TOAD will allow you to run a script with SQLPLus you get the best of both worlds, context sensitive editing and the full power of SQLPlus (When you say to run the script with SQLPlus it actually starts SQLPlus and passes the script to it). ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, August 01, 2008 10:07 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client And you can spool results to a file? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Friday, August 01, 2008 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client ** I have been using TOAD for a number of years now. One of the features is to be able to run a script with TOAD, SQLPlus, or QSR. This way you can use the ability to popup a list of fields for a table or view and check your code before running it. Fred ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, July 31, 2008 8:29 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle SQL Client Toad is pretty good too.. I haven't used either toad nor sqldeveloper that frequently as I'm pretty comfortable with sqlplus although it sucks to a certain extent.. I am not sure if you can enable spooling on toad or sqldeveloper but I need that feature so badly at times while developing sql scripts that I didnt care moving away from sqlplus and finding out if that were possible on toad/sqldeveloper Joe ----- Original Message ---- From: Jill E <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, July 31, 2008 5:09:26 PM Subject: Re: Oracle SQL Client Greetings Christie, SQL Developer is my graphical tool of choice - http://sqldeveloper.oracle.com Jill Anderson On Thu, Jul 31, 2008 at 10:24 AM, Pargeter, Christie :CO IS <[EMAIL PROTECTED]> wrote: ** Hi all - I have recently moved from working with an MS SQL server to having Oracle as my db. Is there a good gui client that I can download (hopefully free) to see all the tables in the db and running basic sql commands? Thanks!! Yes, I am feeing a bit spoiled to lose Enterprise Manager. ARS 6.3 Oracle 9 -------------------------------------------------------------------------- Christie Pargeter Legacy Health System IS - Programming SR Technical Analyst [EMAIL PROTECTED] System Office tel: 503-415-5149 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ No virus found in this outgoing message. Checked by AVG. Version: 7.5.526 / Virus Database: 270.5.10/1585 - Release Date: 8/1/2008 6:39 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"