DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: DATAFILE RESIZE !!!

  1. #1
    Join Date
    Dec 2000
    Posts
    5

    Angry

    OK guys and girls and dbas and whatever outside in the real life exitst :)

    My Prolem:

    I have a .dbf file calles users.dbf ...
    the size of the file is about 4.5GB. Now we have
    created a whole new Database on that machine ...
    now the old file still got schemas which i need to transfer
    to the new database. BUT ... theres no more disk space left ...

    Now i need to know: Can i either resize the .dbf without altering the table or moving the whole DB to another ServerSystem ..(for example an NT Oracle Server) and then move it back to the Solaris System

    Thanks alot

    Florian Kirchlechner

    ***********************************************
    OK YOU GOT A JOB AS WEB PROGRAMMER..................
    OK HERES THE ORACLE ... HAVE FUN WITH IT .............
    Florian Kirchlechner (DBA... but not as wished)
    ***********************************************


  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Yes, just resize the dbf. You need not transfer anything around.

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Wink solution maybe


    Well you have a couple of solutions.

    The first thing I would do is eliminate any files you no longer need. Maybe achived log files are taking up a bunch of disk space? Maybe your cold & hot backups are taking up a lot of disk space. Maybe some old exports are taking up disk space?
    Sometimes I will remove a tablespace, but forget to delete the old datafile until I find it months later sitting in a directory. I definately know my backups take a lot of space so I try to delete those once I know that they have gone to tape.

    Have you tried defragging the current tablespace?
    "alter tablespace users coalesce;"

    Other Tablespaces/Datafiles are possibly taking up a lot of disc space ...

    If you have already tried all of this lemme know and I'll give you more suggestions.

    - Magnus


  4. #4
    Join Date
    Dec 2000
    Posts
    5

    Heya Magnus

    Thanks all for reply,

    but alter tablespace? ... thought that will drop the tables into a temp Dat?

    Correct me if im wrong ....

    Or maybe can anyone write me a step by step guide who to do that right ..

    im not an oracle expert ... but an sql programmer :)

    Thanks alot to all

    Florian Kirchlechner

  5. #5
    Join Date
    Oct 2000
    Posts
    34
    You can use Reorganization Wizard in Tuning Pack in Enterprise Manager 2.1

  6. #6
    Join Date
    Oct 2000
    Posts
    34
    if version of database is Oracle8i

  7. #7
    Join Date
    Dec 2000
    Posts
    5

    Lightbulb It is 8i ... 8-1-6

    I will give it a try ... and searching after that tool :)

    Thanks alot so far

  8. #8
    Join Date
    Oct 2002
    Posts
    391

    Re: solution maybe

    [QUOTE][i]Originally posted by jgmagnus [/i]
    [B]
    Sometimes I will remove a tablespace, but forget to delete the old datafile until I find it months later sitting in a directory.
    - Magnus [/B][/QUOTE]


    okay, when u remove ( drop ) a tablespace, doesnt the physical datafiles are dropped as well?

  9. #9
    Join Date
    Jul 2004
    Location
    Gurgaon
    Posts
    2

    Exclamation Re: Re: solution maybe

    [QUOTE][i]Originally posted by yls177 [/i]
    [B]okay, when u remove ( drop ) a tablespace, doesnt the physical datafiles are dropped as well? [/B][/QUOTE]

    No Dear! you have to delete the physical files manually.
    -Jonathan
    \\|//
    (o o)
    ^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width