Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2005
    Posts
    127

    Unanswered: Cleanup - releasing the memory resources from oracle DB

    Hi,

    I ve an Oracle 9i Database installed in a Windows Xp machine. It has occupied around 15 GB of the Hard disk. We planned to clear the space for other activities. Now i need to take a back up of the Oracle db,

    1. How could i generate the back up in the form of SQL scripts. ie.., given the back up scripts i should be able to create the database , tables and feed it with the data.

    2. Even though I ve dropped some users, the memory space has not released, it still occupies 15GB of the memory. how should i relieve the memory acquired by Oracle.

    Kindly advice me on this.

    Regards,
    Sn

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    given the back up scripts i should be able to create the database , tables and feed it with the data.
    Make a full export using the exp utility:
    http://download-uk.oracle.com/docs/c...a96652/toc.htm

    It won't be a "SQL Script" but a dump file. The imp utility can then re-create the full database from that file.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >The imp utility can then re-create the full database from that file.
    Incorrect statement above.
    The imp utility REQUIRES a functional and online instance into which it loads the data.
    So this begs the question as how do you plan on re-create an empty DB?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by anacedent
    >The imp utility can then re-create the full database from that file.
    Incorrect statement above.
    The imp utility REQUIRES a functional and online instance into which it loads the data.
    So this begs the question as how do you plan on re-create an empty DB?
    You are right, but the question was to take a backup to "create the database , tables and feed it with the data" which can be done with exp/imp

    I am not aware of a complete backup that would include the setup of the Oracle installation (other than making an image of the Harddisk)

  5. #5
    Join Date
    Feb 2007
    Posts
    71
    Quote Originally Posted by shammat
    You are right, but the question was to take a backup to "create the database , tables and feed it with the data" which can be done with exp/imp

    I am not aware of a complete backup that would include the setup of the Oracle installation (other than making an image of the Harddisk)
    i think its because IMP and EXP also creates the schema?

Posting Permissions

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