How to resize Oracle 8 database ?

Hello:

Im new to Oracle. I have deleted lot of records in some tables, and its necesary to resize the entire Oracle 8 database (running over NT).
Which is the simplest way to resize such database ?

Thanks very much.

Rob

Comments

  • : Hello:
    :
    : Im new to Oracle. I have deleted lot of records in some tables, and its necesary to resize the entire Oracle 8 database (running over NT).
    : Which is the simplest way to resize such database ?
    :
    : Thanks very much.
    :
    : Rob
    :
    Rob it is batter to resize ur datafile .u can extend ur datafile size but i think u can't reduce it.and if u want to reduce urs database size ,u can export urs important data and recreate urs databse and then import urs desired data.hope fully it will work.

    Thanx

    Tanveer Haider

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion