Results 1 to 5 of 5

Thread: partitionig

  1. #1
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212

    Unanswered: partitionig

    How can I enable partitionig in Oracle 9.2 on windows XP platform?

    select parameter, value
    from v$option
    where parameter = 'Partitioning'

    returns FALSE

    and I need to be enabled. Can someone help me? Thanx

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    With Oracle Universal Installer, choose Custom install and select partitioning.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    Thanx
    but I don't understand how to change this parameter on existing
    and runnig database/sesion...

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    1) Shutdown database.
    2) With OUI install partitioning option.
    3) Startup database -- parameter will change.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    Hi,
    I shuted down the database, but now, when I'm starting it up oracle
    generate message: SID given in connect descriptor could not be resolved.

    I havent changed any configuration in tnsnames, init.ora etc.
    Listener is runing. I don't know where is the problem...

Posting Permissions

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