Hi everybody,
I have problem here.I have to run a sql script with instructions below Even i tried everthing in order regarding these instructions down it did not extract the files to the directory and it did not appear in console that the files are being extracted as written below at Step 4. It just had shown 'Session Altered' then 'Disconnected.....'.
My Database informations;
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
Prerequisite:
DBA access on the Oracle Database is required.
Step 1 | Logon to the Unix server and create temporary directory where you would like to run the script from - e.g. /tmp/OracleExtracts where OracleExtracts is the newly created directory under /tmp, for the script to run and to store the extracted output files
|
Step 2 | Change to the temporary directory created in step 1 using ‘cd’ command (i.e. cd /tmp/OracleExtracts ) and copy the oracle extraction script (EXTRACT_SCRIPT.sql) using ASCII mode of ftp |
Step 3 | Connect to Oracle database with Database Administrator privileges |
Step 4 | Run the script at SQL prompt (i.e. SQL> @EXTRACT_SCRIPT.sql) |
| During execution of the script, the details of the files being extracted are displayed. While the script is being run the output files .csv extension are stored in the directory from where the script is executed. |
Step 5 | Zip the .csv files and send the zip file to AERS India contact for further analysis |
I have done each instruction, i have logged on unix system with sysdba priveleges,i have created the file in a directory just like shown above. In console (Secure CRT) that i used to connect my IBM aix server,it was not showing the extraction.
What could the problem be?
If you help me, i will be so thankful to all you guys.
ALL REGARDS...