Results 1 to 2 of 2

Thread: Tips for Oracle on Windows > Migrated from MSSQL

  1. #1
    Join Date
    Sep 2015
    Location
    TX
    Posts
    1

    Tips for Oracle on Windows > Migrated from MSSQL

    All of out databases tools have now been converted tor Oracle from MSSQL in the past year.

    I was wondering if you experts had any advice for tasks/ tools that were routine when using MSSQL that I am finding hard to live without.

    1. xp_cmdshell - How or what tools do you use to batch Queries or updates from Oracle remotely across multiple servers. xp_cmdshell would do the most routine tasks that you could run from a CMD prompt while also executing queries. In Oracle I have yet to find a tool that matches this.

    Also Oracle seems to order queries on odd ways. It will pull the correct data but the result set in an order that I would normaly expect IE.. Alphabetical or in numerically.
    Have you experienced this ?

    Also any tip for Powers hell with Oracle ? Power shell is new on my plate and am finding it a little over whelming.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Power shell is definitely overwhelming but it is powerful scripting tool. You can use combination of powershell and sqlplus to do the remote execution.

Posting Permissions

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