Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dates in Oracle.. a Y2K question....

Re: Dates in Oracle.. a Y2K question....

From: Joel Garry <joelga_at_pebble.org>
Date: Fri, 14 Aug 1998 17:41:11 GMT
Message-ID: <slrn6t8tmb.8h8.joelga@pebble.org>


On Fri, 14 Aug 1998 14:00:14 GMT, Oracleguru <oracleguru_at_mailcity.com> wrote:
>Joel,
>
>I agree, but is that the case though ?
>
>There are lots of contributors such as Thomas Kyte, Andeas Prusch and you
>that give good detailed answers but is it your hobby or is it the company
>that you work for that wants you to do it. I don't have that luxury..

Hobby.

>
>Anyway I have learned a lot from this news group and I appreciate and enjoy
>the details that you guys give very much.
>
>But, then again, I have seen answers like "create database link" or "look
>in a certain manual". I don't give answers like that. But you cannot
>avoid that. If I have details and it does not take too much time I will
>give it.

RTFM is a fine old tradition, perfectly appropriate in newsgroups that get 100's of posts a day _after_ being split into subgroups.

>
>I still believe what I said. Again most of us have enough experience to
>take the ball and run, otherwise we will not come to this newsgroup,
>because lot of answers will not make any sense to a Newbie.
>
>By the way, here is an example of an answer that you posted. Did it really
>answer the question? I did not get the impression that you knew Oracle
>financials. May be there is another way to defragment
>Oracle financials tablspaces which may contain certain types of tables.
>Again I don't know.

Maybe, I don't know either. That's why we need to know what the persons idea of defragmenting is. I would hope financials don't use different definitions than plain old Oracle, but I would not expect a newbie to use the same definitions. And yes, it did answer the question, use exp/imp or a third party tool. It also gave several avenues of research the person may want to pursue. The person did not say whether she had had DBA training, but judging from how basic the question was, I felt comfortable in assuming, little. Remember, Oracle tells newbies to export/import the entire database, and considers defragmenting of specific objects a more advanced operation. For all we know, they might be running a V5 db.

>

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Fri Aug 14 1998 - 12:41:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US