converting ctl file to toad database

Posted on 2009-02-11
Last Modified: 2013-12-18
I have a ctl file with me  and i want to import data into the database tables, how do i do that
Question by:ORACLE_HELP
    LVL 23

    Accepted Solution

    For 50 points you are not likely to get a lot of conversation on this, but let's see if this helps.  By "importing into a TOAD database", I presume you mean to use the Toad For Oracle software, to log onto a database, and then use its import wizard with your parameter file.  I'm using TFO 9.7, and my sequence is Database | Import | Data Pump Import Wizard | Load existing parameter file | Next.  If you have used export instead of data pump export, then make the change in the third step.
    Is this on track, or do you need help with the import syntax?
    LVL 23

    Expert Comment

    In the absence of participation I believe {23621606} adequately answered the initial question.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    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…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    746 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

    15 Experts available now in Live!

    Get 1:1 Help Now