Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009

    Unanswered: How to Allocate a Saperate Tablespace for Stored Procedure and Views


    Can i create a seprate Tablespace for Stored Procedure and Views in Oracle 9i & 10g . Like tables.
    if yes then how we will write a script to allocate a Seprate tablespace to view and Stored Procedure give me example.
    and if no then how i would know that which tablespace is getting allocated for Stored procedure and Views in oracle schema.

    Need help on urgent

    Thanks in advance

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Need help on urgent
    Why is it urgent for me to answer these questions for you?
    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.

  3. #3
    Join Date
    Jun 2009

    I know it is not urgent for you.

    Mistakly i use the word urgent i Apology for that.

    but i need your suggestion on above question that is it possible to allocate the tablespace for stored Procedure and Views like table or not.


  4. #4
    Join Date
    Mar 2007
    No. For your second question, what about having a look into Database Concepts book? It is available with other Oracle documentation e.g. online on

    Some interesting parts from the one for 10gR2:

    [Edit: formulation corrected]

Posting Permissions

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