DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2000
    I am trying to set trace on an instance. I have no access to the server that this instance is on, but I can access this instance through my tnsnames entry.

    When I set trace on the trace file is created on the server. I want to change this so the file is created locally on my NT box.
    The Oracle documentation says that I can do an 'alter system set user_dump_dest=new_destination' in order to change the path and set it to a local path on my PC.

    On trying this I get error messages that says that I am specifying an invalid path. Is this command trying to look for the directory on the server where the database instance resides? Is it even possible for me to try and make it to point to my local machine and not this remote server.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2000
    Silver Spring MD USA
    I have not tried this, but it may be possible if you map your file system to the host server so that the host server can write to it as if it were its own file system. Then issue alter system statement.

  3. #3
    Join Date
    May 2000
    Portsmouth, NH, USA

    Thumbs down don't think so

    i don't believe you can do this.

    I recommend mapping to a PATH on the local server and then creating a .BAT and .CMD file to extract the data and throw it onto your local machine.

    am i wrong here? i believe you need to do it that way ...

    - magnus

  4. #4
    Join Date
    Oct 2000
    once i have done the way maachan told. it worked fine......
    Pao de dabba

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.