Re: Defragment

On Thu, 13 Aug 1998 19:01:07 GMT, laurencen_at_my-dejanews.com <laurencen_at_my-dejanews.com> wrote:
>Hi
>
>I am new at the role of the DBA and I have no prior experiences with Oracle.
>We have Oracle Financal applications and I was wondering what I need to do
>when I am ready to defragment a tablespace. An example: GLDX tablespace needs
>defragmented. What are the necessary steps I could take?

There are a number of answers to the question, all of them beginning with get some DBA training.

The classic way to defrag an oracle tablespace is to use the exp/imp utility. The expensive/cool way is to buy a utility. The choice depends on how big your database is and your budget and time constraints.

See the section "Reducing Database Fragmentation" in the Oracle Server Utilities Guide, but remember you really don't have to blow away the entire database.

I've put together a list of links you might browse to find things like FAQs, at http://ourworld.compuserve.com/homepages/joel_garry/oracleln.htm

You might also consider using dejanews and altavista to search for the answer before posting. Between that and the manuals we can then answer the question using the same definition of defragment, perhaps. For example, I just searched for "Oracle defragment tablespace" at http://www.altavista.digital.com, and saw Oracle FAQ: Third Party Admin Tools, among other things.

If you don't have a browser, your life as a DBA will be tough. No training, tougher.

In general, you might want to put the versions of software you are asking about in your question, it often makes a difference.

>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

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 Thu Aug 13 1998 - 19:02:23 CDT