SQL Loader Concept in oracle

SQL Loader is utility to load external text file into oracle database ;
it has 3 files;
1.control file
2.data file
3.log file;

example
data file look like "Salary.txt"

1,2,3,4
11,22,sd,44
22,33,44,55

control file look like "Salary.CTL"

LOAD DATA
INFILE 'C:\SALARY.TXT'
INTO TABLE TEST1
FIELDS TERMINATED BY ','
(A CHAR,
B CHAR,
C CHAR,
D CHAR
)

AFTER THAT FIRE THE COMMAND

sqlldr user_name/pass@connect_string control=c:\salary.txt log=c:\salary.log

URL to Mail from Application Server 10g

http://ip_address/reports/rwservlet?server=Report_Server_Name+report=location_of_report+userid=user_name/pass@connect_string+desformat=pdf+DESTYPE=mail+DESNAME="jainarayan5484@rediffmail.com"+from="jainarayan@surya.co.in"+subject="hi"

This URL used to Mail a Report

Flashback Query

Select * from table as of SCN timestamp_to_scn (systimestamp-1/1440)

it will retreave before 1 min. data

RMAN Backup (Full and incremental level 0)

 {
sql "alter system archive log curreent";
backup spfile;
sql "alter database backup controlfile to trace";
backup incrmental level 0 cumulstive as COMPRESSED BACKUPSET tag
'%FULL_WEEKLY_LEVEL0' database include current controlfile;
}

FRM-92101 Forms Server Failure

IF Application Server refuse the connection then

do the following
1.go to services then click the property of  infrastructure-Process-Manager > Click Log-On Tab and then
Check Allow Service to intrect with desktop and then apply;
2.Change the Registry Value
HKEY_LOCAL_MACHINE/system/CurrentControlSet/Control/SessionManager/Subsystem edit Window Property Parameter
SharedSection from 1024,3072,512 to 1024,3072,1024
3.Reboot the system