To create a tar file.
login into unix(putty):
Enter the IP Address,Provide Username/Password
To go to defined schema cmd: sudo su - schema name
pwd command used to shw the path,
cd .. command used to caom back from specified path,
ls command used to list files
to compile a file ./filename.extension
Creating a tar file:
Place the specified sql,sh files in bin(sh),sql(sql) if particular top folders.
sql file contains the views code to be created,sh file contains the script path to execute.
now from the particular path create tar file using command,
tar -cvf /xxhr/per/file.sql
/xxhr/per says the location of tar files from where it is taking,can add sequence of file paths too.
While compiling special characters may appear to remove
shift ;%s/.$=>:%s/.$
:wq
(save and quit)
quit ctrl z
Oracle Technical Experience and Test Cases Shared from different resource and through self leanings.
March 29, 2010
Subscribe to:
Post Comments (Atom)
COALESCE-SQL
Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...
-
In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
-
Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
-
WIP Migration: Create a job in Work in Process 1. Create a job with item which is billable on and define routing sequence for the ...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.