Log On to Toad Using Sysdba

Posted on 2005-05-16
Last Modified: 2013-12-12
Hi guys

i am using  free version of toad 6. I want to logon  using  sys  as sysdba in order to use explain plan feature of toad.

Toad has following login screen which asks for the fields such as :




can anybody tell me how exactly  i use sys/pass as sysdba  in order to login as sysdba.

I tried all combinations and got  frustated at the end!!!

Question by:rahulnimje
    1 Comment
    LVL 8

    Accepted Solution

    I'm not sure this feature is enabled in the free version, and I can't remember version 6. The actual version is 8 and the login screen has a combobox "Connect as" (with options Normal, SYSDBA and SYSOPER).

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now