RE: Ticket tracking system

I better refrain from kidding in the future... :)

Solution 5 was...

5. Get an infinite number of monkeys to type on an infinite number of keyboards opening an infinite number of tickets, eventually the correct ticket will be opened up. Don't place your redo logs on RAID 5 devices, this could cause a bottleneck during this period.

• E

-----Original Message-----
Sent: Tuesday, April 02, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L

Solution 4 is not dumb. We use it frequently - it allows retrieval of tickets "marked as closed" as well as providing a bit of history for the ticket. If you use this technique, David, you must keep in mind that sooner or later you must actually "delete" the old closed tickets. We generally set up a purge schedule that removes any closed items after they reach a certain age limit. We also have an archive schedule that places a copy of any changed item on CD-ROM on a daily interval. This allows us to retrieve any ticket, if necessary - though it requires operator intervention to reload the ticket.

• Ron

> -----Original Message-----
> From: Post, Ethan [SMTP:Ethan.Post_at_ps.net]
> Sent: Tuesday, April 02, 2002 4:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Ticket tracking system
>
> Manager to David...
>
> "David, this is your manager speaking. Larry says he opened 10 tickets
> last
> month to get the Brady report fixed. Is that true?"
>
> ok enough of that let's ponder some possible solutions...
>
> 1. Have everyone print out a copy of their ticket and then submit it back
> to
> you to re-enter if they want to re-open it.
> 2. Use log miner to log your archive logs. Find the SQL to recreate the
> ticket then run it again against the database.
> 3. This one is really just a better idea for #1...have everyone do a print
> screen of each ticket then create a database that allows people to upload
> the picture of the ticket. Save those and you can refer to them if you
> need
> to re-create a ticket.
> 4. This last solution is really dumb but also might work...instead of
> deleting the record perhaps you could just add a status column to the
> table
> and then mark it as closed. Then you could re-open it using an update
> statement.
>
> - Ethan
>
> -----Original Message-----
> Sent: Tuesday, April 02, 2002 1:38 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I develope a ticket database for people to open, close, re-open ticket to
> update using oracle database. My question is how do I use SQL command to
> let people re-open a close ticket for updates? When someone close a
> ticket,
> delete command is executed and data is gone. Please advise.
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
> INET: david.m.nguyen_at_xo.com
>
> 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 list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling 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: Post, Ethan
> INET: Ethan.Post_at_ps.net
>
> 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 list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling 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: Morton, Ronald D
  INET: rdmorton_at_switch.com

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 list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling 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: Post, Ethan
  INET: Ethan.Post_at_ps.net

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 list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling 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).