Re: Scripts to reengineer a DB / recovery speed-up

Go to Cool-Tools website http://www.cool-tools.co.uk/ and have a look at the Databee DBA Tool Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

RE: Agnostic references for Pracle v SQl Server 2000

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0

Re: DBA work load

aren't going to be able to recover those 3 mission critical databases if they were to crash when you are 2 continents away skiing or surfing. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http

RE: Way of extracting record

Cool Tools have a tool that can assist with this The Extraction and load tool from Databee http://www.cool-tools.co.uk/ Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com

Re: Advice needed on move to Sun 15K (losing spindles)

, I never understand why these vendors insist in building systems with so little hardware Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone

RE: Oracle list for developers ??

Actually there is and it runs of the fatcity servers go to the ODTUG website http://www.odtug.com and the details to sign up are there Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http

Moving tables from one schema to another

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

RE: Rant-Rant

I didn't know that they gave Managers jobs to people under 20 :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461

Rman duplicating failing when setting redo logs

wrong with rman or am I doing something wrong with my setup Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane

Re: system tablespace with oracle software on same

and alert log and probably at time access code that resides on the disk and along with that you want it to keep the dictionary up to date in the system table. I see a potential conflict with that. My 0.02c US today Cheers -- = Peter McLarty

RE: Listener Log Aging Script

at inode in filea so if you intend to truncate then the cat /dev/null cleans out file a whilst all contents up to that point are now in fileb. i think most unixes allow filea to delete its contents HTH Cheers -- = Peter McLarty E

Re: efficient way to duplicate db on another unix host?

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile

Re: UNIX Q: How do I delete files beginning with #

I assume that you are talking about Unix is so the use rm #Column to get rid of it Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0

RE: 20 Instances 1 Machine

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

Re: Unix Solaris forum.

www.sunmangers.org will do it for you Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia

Re: Unix Solaris forum.

try www.sun-managers.org -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

Re: OT: user CGI-BIN directories

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

RE: RE: Dba tools on NT

Looks OK to me, seems about right Although when you start using Macros and such the readability drops a little as it can take a bit of jumping around to understand it. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical

Re: Simple favor from the guru's

the alert log though part of the instance So now where did I go wrong Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane

Re: Convert PL/SQL to Java

classes are added to JDeveloper's Navigator pane for the Project and Package you specified. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61

Re: Win2000/8.1.7.3.0/SQL

might like to investigate the SORT_AREA_SIZE parameter or maybe just look at increasing the available memory to the instance. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com

Re: Viewing Data in Oracle Apps Tables

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

Re: PRO*C question

If you run the installer you can view a list of installed products. If the Pro C stuff isn't listed then it needs to be installed. the OraInventory under ORACLE_BASE is where this information is kept on the system in question. Cheers -- = Peter

Re: [Q] security between Cold fusion and oracle database?

of security. It will just take them a lot longer to work out what is on the other side of the firewall at that port. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical

Re:RE: Returned mail :

will see though if I can get the list added to the trusted email sites. then regardless of content the message will get through, viruses generally excluded. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant

RE: Consulting Position Available-Oracle DBA/Developer/NYC

Or SQL server -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

Re: Oracle and Delphi

Another product to consider is ODAC for Core Labs http://www.crlab.com/home.html Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7

Re: newbie seeks career direction: become a DBA or DEVELOPER?

out in some sort of entry role, the younger ones via hep desk or PC support roles and older ones via operator or grad programmer roles. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http

Re: OT: Miracle Database forum in Sydney - get together Sunday night

Bruce et all myself and a couple of workmates will also be in Sydney early evening, and will be finding a place for a beer so maybe we can catch up Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW

RE: Data Warehouse experts, a simple question for you| Outdated?

And that means we can all now ask Rachel our Datawarehousing questions and not RTFM :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone

Re: SQL Question

. Mine the delimiter is a fixed value in code, it could be altered to use a runtime selected value. I can provide the source if it would be of use. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW

RE: Production Database Open Fails after Mount

an empty linked list, hash table or some such to manage the procs up to the max value. -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461

Re: How do YOU use Java in the DB?

. I would almost certainly get Java to handle any OS functions. -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane

RE: SqlServer Interview Questions

tell you much about it but it has one and it has a number of wait events that it uses. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61

RE: Management Reports

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

Re: Exp Imp User ?

RTFM http://tahiti.oracle.com -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402

RE: Oracle AQ MQ Series

appropriate logic and you build a messaging broker. It sorts of spoils their pricing fun with these products Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

Re: Oracle client won't install on Windows 2000

the installation CD to the HDD and make the changes, then install from the HDD. Voila! CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical

Exporting stats for a production server to a dev/test server

Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http

Re: 9iAS Application Server: Win2k vs. Linux?

As you have Unix skills and therefore could handle Linux OK, then unless you will have issues with people about support for Linux I would offer to save the organisation money by using Linux for your platform Cheers -- = Peter McLarty

Re: a couple of questions

Sheesh Has Oracle employed some MS developers, sure sounds like one of there brain dead ideas :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

Re: URGENT PLEASE ! tns service deletion and recreation

With 8i you could use the net 8 assistant, or manually edit the listener.ora file to make the changes HTH Peter At 09:45 PM 22/08/2001, you wrote: OS: NT 4.0 I need to delete the TNS Listener service . and create a new one . How can I do that ? TIA Bunyamin

Re: OT: Unix - performance tuning (vmstat 5)

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter

Re: Alter tablespace add datafile

://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

RE: 32-bit vs. 64-bit on HP-UX 11.0

over as part of the 11 upgrade. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61

RE: Do programmers tune SQL?

DBMS_UTLIITY.COMMA_TO_TABLE does but with out the restrictions on what can be in the input string. Quite an interesting exercise for learning about Java in the database. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical

RE: Database shut itself down

them it won't happen Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094

Re: Dynamic create and execute procedure

What !!! -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

RE: WHICH UNIX FOR ORACLE?

here at present. but I also havent had a problem with Sun or IBM, Just lucky, maybe Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61

Re: Question about Forms Version

on the ODTUG Dev2k list http://ourworld.compuserve.com/homepages/Peter_Koletzke/ HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303

Re: Question about Forms Version

installed you will need to set the default home for the system back to the 8i home, other than that it seems to work OK Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC

initjvm and rmjvm failing

I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW

RE: initjvm and rmjvm failing

Thanks Bruce The initjvmaux.sql was the key to the cleanup and increasing the Java_shared_pool to 50M got it going properly The metalink notes that I had read suggested 30 so I had 35MB Cheers -- = Peter McLarty E-mail: [EMAIL

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

times that the changes that had been requested helped or hurt the system. -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane

Re: unix df -k .. not giving extact space at point in time

was accessible to the process but was hidden from everything else. You can find them with an inode listing. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

Re: Root Cause Analysis White Papers

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

Re: Solid DB and Oracle (NNM)

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

RE: Solid DB and Oracle (NNM)

no I have done some work with Openview but never tried to deal with database backends, sorry -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61

RE: Licences for testing

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

RE: Telephone Alerts

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

RE: Calling an External Java Class from PL/SQL

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

Re: ftp tools

Leech FTP http://stud.fh-heilbronn.de/~jdebis/leechftp/downloads.html Freeware not ad-ware. Does multi-ftps similtaneously Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane

Re: Morpheus killed my Oracle! Help!

Look in your /etc/services or inetd.conf file. It sounds like Morpheous still has a listener attached to the port and you need to remove the reverence to 1521. If inetd.conf needs editing you will need to send a kill -1 to the inetd process to re read the inetd.conf Cheers Peter McLarty

Re: extenal procedure listener and firewall

and if the port is not in the list then a connection never gets through If you search the archives at fatcity.com you might find something HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane

Re: failed to extend rollback segment ??????

It might be still creating the records, Also I suggest you truncate the table rather than delete the table its usually quicker and then delete after the truncate Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone

RE: 9ias Vs IIS

Try the cert website they may have some incident data http//:www.cert.org HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

RE: Possibly moving to Sun Equipment

are now quoting F3800's where we would have possible put a 4500, The 3800 is a 2 to 8 way box with the new Sparc III CPU's HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane

Re: OT: Solaris

Hi Lisa Hed on over to http://www.sunmanagers.org and subscribe there for a good list regarding Sun Admin. Have a look at the archive http://docs.sun.com/ab2/ contains the sun Administrators Docs This is also a good book http://www.oreilly.com/catalog/solaris8/ HTH Cheers Peter McLarty

Re: Off Topic - Windows XP Dialup connection

Actually unless you have XP Professional you cant join a domain it is one the the things that differentiate HOME from Professional HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461

Re: Off Topic: Australian Visa

here either anymore however knowledgeable staff with strong skills are able to gain employment. The current employment climate is sending a bunch of the paper certified's back to there old fields of employment. HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http

Re: DBCA (DATAFILE SIZE PROBLEM)

Try using Custom it will allow you to do that and more Cheers Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

After logon trigger

t_tmp_stddev ( v_part NUMBER, readings NUMBER) ON COMMIT PRESERVE ROWS'; EXECUTE IMMEDIATE v_CreateString; END; TIA Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile

Re: Architecture Options

that if you have good application Architects then they will know the best fit for your application HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094

RE: Locally managed tablespaces

may need to re-run some loads due to insufficient tablespace area. Timing could be an issue for a live system Cheers Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia

Re: sqlloader question

Have a look at the section in sql loader on applying SQL to fields in theSLQ Loader documents else Is it possible for you to run the data through a Perl script to alter tha data before invoking sqlloader Cheers -- = Peter McLartyE-mail

RE: Help - DBA interview questions I faced

it out long enough to see if I could make IT manager Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61

Re: DDL alter in execute immediate pl/sql procedure - dynamic sql

-- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

Re: XP Professional 9i (YES IT IS A CERTIFIED COMBO ACCORDING TO

They were probably referring to MS patches G Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0

Re: Oracle 8.1.7 on Solaris 2.8?

The last time I tried it ran fine on 2.8 Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402

RE: Becoming a DBA questions

figures always are or should be higher Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

Re: How to change ORA error message ?

Try an exception Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

Re: Re[2]: Becoming a DBA questions

-- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

RE: Dig it - killer freeware editor

You can add your own if you like, see the highlighter directory and the contents of the chl file its just text Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

Re: data modeling

Try this one http://www.datamodel.org/ cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402

TEMPORARY TABLES

and found nothing specific to point the way Any help appreciated -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile

Re: NT questions

without investigating further the purpose of those patches. It is possible you could break something else Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone

Re: procedure error

try changing CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP to CREATE OR REPLACE PROCEDURE Primus_Report AS BEGIN Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP -- = Peter

Re: Import taking up too much room with local managed tablespace

but if it is for a production system then you will need to do your homework -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094

Re: Database Replication

you know what it is exactly you need then we can give you some answers. If there is something in the Oracle documentation you don't understand please feel free to ask away Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical

RE: DBA Vs Apps DBA

Excellent Peter -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

Re: Alias Table Error...why?

I will have a go at it being a.pc_session_user_name = 'tsokol' a doesn't appear to be defined or do you actuall have a table called a Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http

Re: creating a procedure

I think that all you need is a ; before the end You need to close your statement within the procedure body -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

Re: export the schema exclude two tables?

Do you want to make a new schema minus those two tables, if so then try Databees DBA tool follow the instructions and you can build a new schema from your old one. Its pretty simple to use from first impressions Cheers -- = Peter McLarty

Re: Backup Strategy

Yeh I never knew that NT copy could manage keeping the CSN number in sync, oh well you live and learn :-) G -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

RE: NT Scheduled Restart

Title: Database Down Shutdown.exe.is part of the NT resource Kit. So I probably wouldn't class it as freeware. Bill would have a fit. :-) Peter -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of AndySent: Friday, 25 May 2001 2:00 PMTo: Multiple

RE: backspace in Oracle.

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City

Re: Slow query

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Difference between a couple of v* manuals

, any idea where I can dredge it up? Can someone enlighten me Is there 2 manuals as the documentation suggests or is it just a case of poor techwriting TIA Peter McLarty Ph +61 7 3368 6900 Ext 968 System Administrator Astracon (Australia) Pty Ltd Fax +61 7 3368 6999 Milton

Import Problem

: operating system error - error code (dec 79, hex 0x4F) Import file: expdat.dmp this file is with 2.5 GB is there any variable that I need to change for this? I used the ulimit commands options but didn't work. Peter McLarty Ph +61 7 3368 6900 Ext 968 System Administrator

RE: Router filtering

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

  1   2   >