This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| database:oracle [2014/01/27 15:36] – [Useful Commands] tmade | database:oracle [2017/12/09 01:19] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 112: | Line 112: | ||
| create or replace directory EXP_DIR as '/ | create or replace directory EXP_DIR as '/ | ||
| create or replace directory DATA_PUMP_DIR as '/ | create or replace directory DATA_PUMP_DIR as '/ | ||
| - | | + | |
| | | ||
| ==== Connecting SQL*PLUS with a shell script ==== | ==== Connecting SQL*PLUS with a shell script ==== | ||
| Line 171: | Line 171: | ||
| | | ||
| sql>set linesize 300 #Set linesize (lenght) to 300 (max is 32767) | sql>set linesize 300 #Set linesize (lenght) to 300 (max is 32767) | ||
| + | sql> | ||
| + | sql> | ||