This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
database:oracle [2014/01/27 15:36] – [Useful Commands] tmade | database:oracle [2015/03/02 11:20] – [Checks] tmade | ||
---|---|---|---|
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> | ||