converting ctl file to toad database

Posted on 2009-02-11
Medium Priority
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
  • 2
LVL 23

Accepted Solution

David earned 200 total points
ID: 23621606
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

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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

850 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