Running the scripts using TOAD Through SQL*PLUS
Provide the Source Path and the Destination path and execute script from Editor > Execute as Script.
Enter User-Name and Password (E.g. SYSADM@FINC and Infor1) and ensure that the destination folder is created.
- Example to run Oracle
script using TOAD via SQL*PLUS
@'C:\ORCLAI\ExtractORCLAI.SQL' 'C:\ORCLAISQLPLUS' 'US' 'APPS' 'VIS' 'ENGLISH' 'US'
Note:C:\ORCLAI\ExtractORCLAI.SQL is the location of SQL script and C:\ORCLAISQLPLUS is the location for extracted data.
A command prompt window displays the status of the script.