RE: Identification of tables NOT being used in the System.

Title: RE: Identification of tables NOT being used in the System. There was a note previously on a similar theme which I have posted below. The dba_tab_modifications does not show when a table has been selected from which could be a problem for reference data type table which can easily be

dbms_jobs and redo activity

Will submitting jobs via dbms_jobs result, in itself, in transactions being writen to redo logs? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: dbms_jobs and redo activity

Yes, its basically an insert into SYS.JOB$ hth connor --- John Dunn [EMAIL PROTECTED] wrote: Will submitting jobs via dbms_jobs result, in itself, in transactions being writen to redo logs? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John

Locally Managed Tablespaces

Hi, Anyone using LMT for rollback segments ? Any issues , suggestions , ... ? TIA, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: dbms_jobs and redo activity

Yes. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 18, 2002 5:43 AM Will submitting jobs via dbms_jobs result, in itself, in transactions being writen to redo logs? John -- Please

RE: Another partitioning question

Thanks for the help. -Original Message- Sent: Friday, March 15, 2002 11:28 AM To: Multiple recipients of list ORACLE-L John - At last a question I can answer! Anyway I think so. You can partition on a concatenated key. I just did this on our data warehouse and brought query times from

Sql loader - schedule

Hallo, How is it possible to schedule an sql loader script, which is running on network(not unix). Let us say this should run at 6 pm every day. This sqlloader simply loads a textfile into a table in the database. Thanks in advance Roland -- Please see the official ORACLE-L FAQ:

RE: Sql loader - schedule

Not Unix - I will presume NT. On NT you can use the AT command to schedule task. Just type AT at the command prompt. One more thing: activate the scheduling service. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL

Re: Sql loader - schedule

what does running on a network(not unix) mean? any way you can use a scheduler. There are alot of free ones avaiable. On Mon, 18 Mar 2002 [EMAIL PROTECTED] wrote: Hallo, How is it possible to schedule an sql loader script, which is running on network(not unix). Let us say this should run

Oracle DBA- Solaris System Administrator Needed in Cambridge,

Cambridge, Massachusetts Biotech company needs an Oracle DBA/Unix System administrator who has solid Unix Solaris Systems Administration experience . This is a staff opportunity... No sub-contractors or third parties please. * DO NOT send your resume unless you have a stable work history.

Re: Sql loader - schedule

Hi Roland, You could do this via the OEM job system. Or whatever batch scheduling system exists in your environment John [EMAIL PROTECTED] wrote: Hallo, How is it possible to schedule an sql loader script, which is running on network(not unix). Let us say this should run at 6 pm every

RE:

If you close all the gui applications, is there a jre or jrew process still running? You might try killing those completely (that may cause your oracle management server to abort and it will have to be restarted manually) and then restarting DBCA. I don't know about DBCA, but I've seen similar

Oracle9i init.ora file

Hi list, Can someone out there share a Oracle 9i init.ora for a production database on Sun Solaris? Thanks, Mike ** This e-mail contains privileged attorney-client communications and/or confidential information, and is

RE: Fav. Urban Legend...

A I only knew about it (and tried it) in 8i+... thanks for the info!! Rf Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

RE: Fav. Urban Legend...

And hey, it was Sunday morning at 0700 something... what do you expect from me anyways??? :-))) RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away

RE: Fav. Urban Legend...

Point taken... I assume you mean a cold backup in ARCHIVELOG mode... :-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original

Re: Locally Managed Tablespaces

Yes - on 8i and 9i. There were a couple of issues under 8i, where you needed to have an additional rollback segment in a non-LMT (ie SYSTEM) in order to create lmt rollback tspaces and segments, but other than that, there have been no problems so far. hth connor --- [EMAIL PROTECTED] wrote:

Excel to Oracle

Hi All, What is the best/quickest way to move data from excel to Oracle? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

RE: Locally Managed Tablespaces

Antonio, We use LMTs for all tablespaces - except for System, of course. No issues, problems, etc. We're happy. 8.1.7.2.5 on Win2k; ~340GB in 29 tablespaces. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin,

Oracle vs. MS SQL EE vs. SE

I have been asked to compare Oracle and Microsoft SQL Server. I notice that Microsoft has introduced Standard Edition and Enterprise Edition versions. Can anyone point me to resources that will help me compare these versions with Oracle versions? My impression is that Oracle introduced SE as

Another partitioning question part 2

I tried the partition by range feature and didn't get the results I expected. It seemed to ignore the second key when inserting data. create table test_part( id number(11) , owner_id number(11) not null, owner varchar2(30) not null, street varchar2(40)) partition by range(owner,owner_id ) (

RE: Excel to Oracle

Title: RE: Excel to Oracle hi! i would probably just export the table in a portable csv format and then use the oracle sql*loader to import it into oracle. simple but it works! cheers dieter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday,

Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

Ok maybe you will think this is a silly thread, but I've wondered about this before... We (DBA's) use the terms hot and cold backups all the time. I wonder though, when we talk about cold backups if the terminology should not include the mode of the backup: cold archivelog mode backup cold

RE: Excel to Oracle

http://www.oraexcel.com -Original Message- [EMAIL PROTECTED] Sent: 18 March 2002 15:44 To: Multiple recipients of list ORACLE-L Hi All, What is the best/quickest way to move data from excel to Oracle? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Logminer

I get the following error when running SYS.DBMS_LOGMNR_D ERROR at line 1: ORA-06532: Subscript outside of limit ORA-06512: at SYS.DBMS_LOGMNR_D, line 793 ORA-06512: at line 1 Anyone else seen this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn

RE: Another partitioning question

Kirti - Thanks so much for your reply and taking the time to work out an example. I learned a couple of new techniques from your example. That one is going in my files. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 15, 2002 6:53 PM To:

Re: Excel to Oracle

sqlldr David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team

RE: Excel to Oracle

One way that you might consider is going through MS Access ODBC. Link your Oracle tables via ODBC; import the excel data, and then point-n-click up some Access action queries (aka INSERT statements). HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487

RE: Excel to Oracle

I would dump the excel sheet to a text file and use SQL*LOADER to move it into Oracle. Alec -Original Message- [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:44 AM To: Multiple recipients of list ORACLE-L Hi All, What is the best/quickest way to move data from excel to Oracle?

RE: Oracle vs. MS SQL EE vs. SE

Check out the following URL; it will get you started. http://www.microsoft.com/partner/licensing/embeddedlicensing/faqs/sqllicensi ng_faq.asp --Walt Weaver Bozeman, Montana -Original Message- Sent: Monday, March 18, 2002 8:48 AM To: Multiple recipients of list ORACLE-L I have been

Re: CRONTAB JOB

Cron has a log file, generally /var/cron/log (requires root privs to read it). Also check for mail of the user executing the cron job for errors. Hamid Alavi wrote: Hi All, I have a crontab job but this job never started, I have no idea what's wrong, actualy i am not a unix person, here

RE: Excel to Oracle

Hi... Here we use a text file .css generated in Excel and then we use sqlloader... it's very fast.. bye ATT Latin America Alex Tomita Koga - ITS e-mail: [EMAIL PROTECTED] phone: (51) 1 610- extension 2619 Av. Larco 1301 Torre Parque Mar - Miraflores -Mensaje original- De: [EMAIL

RE: Installs and Extra Cost Options

Do you control your databases to such an extent that you can guarantee no one will use one of the unlicensed features? Currently we don't install any option for which we are not licensed, but I am questioning that strategy. The idea of unlinking features which are not licensed is to prevent

Re: Fav. Urban Legend...

Hey, you're an author! I expect perfection, grace and infallibility. ;) Jared On Monday 18 March 2002 07:33, Freeman, Robert wrote: And hey, it was Sunday morning at 0700 something... what do you expect from me anyways??? :-))) RF Robert G. Freeman - Oracle8i OCP Oracle DBA

cannot delete jobs in OEM ???

Hi all, I'm using OEM 9.0.1 on Win2000. On Jobs' Active tab, after I highlighted some jobs and click Remove Jobs, the jobs are still there, and the status shows Deleting, but they are never actually deleted. The agent, ManagementServer are running. Preference Credential user is set with Log

Re: Logminer

Hi John, You did not mention the Oracle version, but I hope this will help. In $ORACLE_HOME/rdbms/admin/dbmslmd.sql (the script that builds DBMS_LOGMNR_D package) there is a line: TYPE col_desc_array IS VARRAY(513) OF col_description; Replace it with something like: TYPE col_desc_array IS

Time Zone convert

Hello, All: In Oracle 8i, How can we convert day/time from the Time Zone that Oracle 8i does not support to GMT (or any other Time Zone)? (Oracle 8i only support about 13 convertions.) I think someone just mentioned this a while ago, but I didn't write it down. Thanks for the info. Steven

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

Hi Robert, Oracle University training uses the terms online and offline and points out that online backups can only be made to databases that are in archivelog mode. Offline backups can be made to either archivelog or noarchivelog databases. John [EMAIL PROTECTED] wrote: Ok maybe you

Re:RE: Oracle vs. MS SQL EE vs. SE

Hu, Looks like Oracle's license model, Smells like Oracle's license model. Wonder who thought of it first, Bill or Larry?? Dick Goulet Reply Separator Author: Weaver; Walt [EMAIL PROTECTED] Date: 3/18/2002 8:44 AM Check out the following URL;

RE: Fav. Urban Legend... Hot vs Cold

Hi all, Notice the renamed heading - this thread has really taken off! Coming back to the issue: While I agree that you should not open the database until after you backup (hot or cold), I am still rooting for a hot backup. If you know the application well enough, you can perform 'selective hot

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

but isn't cold backup is possible only if ur running in noarchieve mode else you have to go for hot backup. BigP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:41 AM Ok maybe you will think this is a silly thread, but

RE:

When I start the OUI I can see the jrew.exe process running. Outside of that I don't see a jre or jrew process running. I can run the OUI but not the dbca or dbastudio. thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seefelt, Beth Sent:

Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

We have a particular database that hangs on a regular basis. Here are the stats and symptoms. Oracle stats -- 8.1.7.3 (highest patch level applied) Solaris 2.7 UTF8 character set Symptoms -- Random hanging.

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

[EMAIL PROTECTED] wrote: but isn't cold backup is possible only if ur running in noarchieve mode else you have to go for hot backup. BigP OK let's get the definitions down first. AFAIK: cold backup := database shut down and an OS copy of all the necessary files. hot backup := place TS

RE: Fav. Urban Legend... Hot vs Cold

John, Yes, and I could kick myself for not thinking of this, mirrors can be a most excellent alternative to backups both production and after a recovery. Of course, it can be an expensive alternative as it requires you to have 2x disk space... :-) But disk is cheap, right...? Or is that yet

RE: Fav. Urban Legend... NOBACKUP!!

John !! Notice the change in subject again !! WARNING** ORACLE WILL NOT SUPPORT THIS KIND OF RECOVERY. * I don't agree with you about the MANDATORY backup. You can still recover the database COMPLETELY if you have

Oracle Gold Support

Anyone else just slightly irritated with the level of customer support offered for phone callers to Oracle now days? Used to be, that if you were a gold customer as we are, you could almost count on instant first line support. Last week I called and was told that a phone call would result in at

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

I can read your question 2 ways, so let me answer it both ways... If you are asking if you can only do a cold backup when in noarchivelog mode, you are correct. However, in archivelog mode you can do cold or hot backup. The procedure is a bit different in archivelog mode, because of the

RE: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

Chris, Just do a ORADEBUG HANGANALYZE and upload the trace file to http://www.unal-bilisim.com 's Hanganalyzer. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Chris Sent: Monday, March 18, 2002 10:28 AM To: Multiple recipients of list ORACLE-L We have a

is Oracle really planning to desupport RBO?

Has anyone heard anthing official or semi-official on this? Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

You can call them whatever you like, nothing in the world will save the clueless person you describe below :-). You are correct in saying it is a training issue, I personally use hot and cold but think offline and online are just fine as well. The issue is that the mode "archive vs

RE:

Memory availability?? DBCA does require a great deal of it. Check your overall available memory (real and virtual). Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

But my concern is this. Say a DBA has been doing cold, noarchivelog mode, backups for a year. Then, he gets this great idea (or direction) to put the database in archivelog mode, but to still do cold (or offline) backups, so all he changes in his backup/recovery strategy is the backup of the

Re: Fav. Urban Legend...

[EMAIL PROTECTED] wrote: platters of his disks. And he did complete that which was called documentation, and then he rested from his labors, and drank Mountain Dew Code Red... nope he drank single malt scotch, neat.;-) -- -- Bill Shrek Thater ORACLE DBA

RE: Disk is cheap?

Robert G. Freeman - Oracle8i OCP wrote: But disk is cheap, right...? Or is that yet another Urban Legend??? Yes, that's another Urban Legend. Disk DRIVES are cheap, disk SPACE is not so cheap. Consider this example: I have a disk cabinet

Re: cannot delete jobs in OEM ???

Leslie, You might want to check that the agent is running on the DB server that the jobs are scheduled, and refresh the node in OEM. If that doesn't work, you could stop the agent, remove the node in OEM, and clean up the *.q files for that agent ($ORACLE_HOME/network/agent), then re-discover

Re: Oracle Gold Support

Freeman, Robert wrote: Anyone else just slightly irritated with the level of customer support offered for phone callers to Oracle now days? Used to be, that if you were a gold customer as we are, you could almost count on instant first line support. Last week I called and was told that a

Learn from my mistakes! Or Helpful DBA hint of the day

In 9.0.1, when you create a DB, you would connect / as sysdba. However, if you also run catalog and catproc while connected like this, Oracle Advanced Symmetric Replication WILL NOT WORK. You *MUST* be connected as SYS as sysdba. It's taken me forever to find this. The biggest clue I had was

RE: Fav. Urban Legend... Hot vs Cold

Well, if you ask many damagement types, they would say it's a myth. :) -Original Message- Sent: Monday, March 18, 2002 12:58 PM To: Multiple recipients of list ORACLE-L John, Yes, and I could kick myself for not thinking of this, mirrors can be a most excellent alternative to backups

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

I agree with your definitionsbut the cold backup in archivelog mode is fundamentally different from one done in noarchivelog more (with respect to online redo logs and control files) if you are in archivelog mode and want to be able to do point in time recovery. Robert G. Freeman - Oracle8i

RE: Fav. Urban Legend... NOBACKUP!!

Gopal, Would you mind posting the procedure for recovering past resetlogs? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 18 Mar 2002, K Gopalakrishnan wrote: I have once recovered a 8.0.5 database on Solaris using the backup (pre RESETLOGS) and the archive logs of pre and

RE: Fav. Urban Legend... NOBACKUP!!

As I said earlier, I agree 100% with KG. Recovery after RESETLOGS is possible I've done several of these types of recoveries in preping for some talks. KG is also right in that this is not supported by Oracle (but is taught in their internal backup and recovery classes!!) RF Robert G. Freeman -

Electronic Laser Forms - Any recommendations?

Can anybody recommend a printing package for Oracle? We have a number of forms that need to be populated with Oracle data. Examples are Report Cards, Progress Reports, Immunization Letters. The format of these changes, so we need to have the ability to modify the ELF in-house. The platform

RE: Oracle Gold Support

They made me purchase customer support before they would even tell me the system requirements for 9i (which I had already purchased, including a personal 2-year license). It turns out that I need to buy more memory and can't install the product. That tee'd me off ! I couldn't get a salesperson

RE: Locally Managed Tablespaces

And the hot tip is that SYSTEM will be locally managed (by default) from 9i.2, which (I hope) will render dictionary managed tspaces to the dustbin. Cheers Connor --- Jack C. Applewhite [EMAIL PROTECTED] wrote: Antonio, We use LMTs for all tablespaces - except for System, of course. No

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

Just to add to the controversy, I often make the argument to developers/users/managers/etc that noarchivelog does not exist. In my opinion, 'noarchivelog' is like waving a flag saying I stand an excellent chance of losing a whole lot of data one day. Some years ago at a place I worked, some

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

Title: RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO Robert, Let me disagree with you. Cold *backup* is the same in archivelog mode and in noarchivelog mode. The *recovery* is (could be) different. Consider the following. I make a cold backup of a production DB, and

process last non-idle time

From v$sesstat - is this in seconds since the epoch? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: CRONTAB JOB

try add the environment varriables into the script file! @L£K Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática

Re: Oracle Gold Support

Robert - I had the same experience a few months back. I griped about it to the person on the other end of the line, and eventually found out that the person I was speaking with wasn't even an analyst with Oracle. Just someone taking incoming phone calls, similar to a messaging service.

RE: Disk is cheap?

I think that with higher priced systems, this does become an urban legend for just the reasons you cite. We run into this problem all the time. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a

Need a delete trigger that tracks deletes.

We need to be able to track what records have been deleted from a table. Our current thinking is 1. A before delete trigger, that stores a unique ID of the all the data in the table. 2. A after delete trigger, which gets the records left in the table. 3. Subtract the two lists to find the

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

I agree... cold can be the same, but recovery is different. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

Unless you're database is being used exclusively for Oracle Internet Directory, in which case Oracle Corp says that traditional methods of DB backup and recovery are not applicable in most cases. And since we're running Oracle ASR, I plan on keeping the RDS in NOARCHIVELOG mode. We're already

RE: Oracle Gold Support

I don't understand this the product (the RDBMS) can be downloaded for FREE from oracle.com.the doc's are free to look at at technet.oracle.com, including specific platform install guides which contain product requirements (as seen here)

RE: Learn from my mistakes! Or Helpful DBA hint of the day

I do not see a difference between connecting / as sysdba or sys as sysdba the final result is connecting as SYS. I do not think this has anything to do with the errors you had. Regards, Waleed -Original Message- Sent: Monday, March 18, 2002 3:43 PM To: Multiple recipients of list

RE: Need a delete trigger that tracks deletes.

Why not simply a Before Delete trigger that copies the row about to be deleted over to a duplicate table. This way you can know exactly what the data was before it was deleted. Of course, if you only care about a certain field or group of fields you can always just copy those fields instead of

Re: Fav. Urban Legend...

init.ora parm: _MAKE_SQL_RUN_FASTER= valid values: 8.0 = true/false 8.1 = x where x is a number between 1 and 100 9.0 = x or unlimited -- this gives you the ultimate speed in queries joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET:

RE: Fav. Urban Legend... Hot vs Cold

Bob, Yes... For Business Continuance (HP) or SRDF (EMC) kinda solutions it is becoming an urban Legend. I will give you an example... 1.2 TB usable disk spsce by HP's XP disk solution costs us almost 800 K USD , that too after all kinds of discounts. Like John said, considering it saves a whole

RE: Oracle Gold Support

Try to find a way to get turbo-charged... http://www.macwhiz.com/articles/art-of-turboing.html -Original Message- Sent: Monday, March 18, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Robert - I had the same experience a few months back. I griped about it to the person on the

Re: Oracle Gold Support

Don't blame the support tech. person, I'm sure they are more stressed that we are. Oracle support has been going into http://www.theshitter.com for some 2 years now. Remember when you could get a 1-off patch Now all I hear is upgrade to the current release, or it's fixed in the next

RE: Fav. Urban Legend...

Robert - So THAT is the title of your next book. I'm primed to buy it already. I just recalled a legend, maybe. Disk is 10,000 times slower than memory, so memory access times are infinitesimal compared to disk access. Cary Millsap covers this in his Hotsos Clinic. He has run tests that prove

Re: Need a delete trigger that tracks deletes.

Sure. Create a journal table whose structure is the same as the table of interest, with the addition of user, timestamp, and whatever else you're interested in tracking. In your before delete trigger, just write the about-to-be-deleted row to the journal table, with the additional columns

RE: Oracle Gold Support

Oracle is shunting everyone to METALINK support. Fundamental misunderstanding on their part. They think because we administer computers that we LIKE to use computers. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 18, 2002 1:43 PM To:

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

Connor - Good points, but obviously there are exceptions. We have a data warehouse that we keep in NOARCHIVELOG mode. After the weekly load we do a cold backup. However, lately there has been talk of some updates during the week, so that may have to change. Dennis Williams DBA Lifetouch, Inc.

RE: Need a delete trigger that tracks deletes.

Another idea is to mark the record deleted instead of physically deleting it. Regards, Waleed -Original Message- Sent: Monday, March 18, 2002 5:18 PM To: Multiple recipients of list ORACLE-L We need to be able to track what records have been deleted from a table. Our current

RE: Oracle Gold Support

Microsoft used to give out memory requirements for their software, and it seems to me almost every time they underestimated the minimum requirements. I myself prefer no information to misleading information. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin

RE: Oracle Gold Support

At the time, I was brand-spankin' new to Oracle, and didn't even know technet existed. I was looking at the product info pages where you purchase products (which usually at least show system requirements when you click on the more info button type of thing). Since I couldn't find the data

RE: is Oracle really planning to desupport RBO?

All I know is that the RBO doesn't take advantage of new features as they are added in newer versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, March 18, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Subject:is

RE: Electronic Laser Forms - Any recommendations?

Oracle reports? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, March 18, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject:Electronic Laser Forms - Any recommendations? Can anybody recommend a printing

RE: Oracle Gold Support

Having some data would have been far better than no data for me -- would have saved me several hundred dollars. I would have purchased 8i instead. I'm learning Oracle -- the classes aren't even for 9i anyway. They're for 8i. As it is, I wasted several hundred dollars. Cheers, JoJo

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

Here is en exception: I happen to administer a couple of data mart databases, that are loaded once or twice a month. Both run in noarchive log mode. This is how these have been set up when we started back in 1998. We take cold backups after the data load, table/partition analyze. It takes 5

RE: Fav. Urban Legend...

And here I am trying to make things so complicated ;-) And for repeat billings, create an invisible DBMS_JOB (_invisible_jobs = TRUE) that calls a routine that resets the value to 1. Schedule to run 6 months once your contract ends. Sure to get a call. Larry -Original Message- From:

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

Hi, Pardon me if I am wrong, I thought the only reason for the database to be in archive log mode is so that I can recover the database up to the time when the database crushes. For example, we do cold backup nitely. If the database were to crush etc at 2pm, I would be able to recover my

EDI Translator

Hi Friends : Does anyone use EDI Translator ? Is it a toool of Oracle's ERP ? Does anyone use translation from EDIFACT using pl/sql ? What resource is used for it ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET:

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

No no.. You are correct. In my case, since no changes are made to the database other than the data loads, and there are no issues about recovering from the last cold backup the downtime involved, we can live with noarchivelog mode. That's all. Cold backups with noarchivelog mode are useless

RE: Fav. Urban Legend...

We'll remember that Jared when your book comes out;-) -Original Message- Sent: Monday, March 18, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hey, you're an author! I expect perfection, grace and infallibility. ;) Jared On Monday 18 March 2002 07:33, Freeman, Robert

RE: is Oracle really planning to desupport RBO?

They have been saying that for years. First they must rewrite their own system. -Original Message- Bill Sent: Monday, March 18, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Has anyone heard anthing official or semi-official on this? Bill Magaliff Framework, Inc.

RE: Oracle Gold Support

Report the rude dude. However, I have gotten really good response from using Metalink (also Gold support) for level 1 tars. The good thing is, since you are putting it in it gets in correctly. I actually think Oracle has greatly improved their support. Are they perfect? No, but I do believe

RE: Disk is cheap?

touché -Original Message- Mark Sent: Monday, March 18, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Robert G. Freeman - Oracle8i OCP wrote: But disk is cheap, right...? Or is that yet another Urban Legend??? Yes, that's another Urban

  1   2   >