Differences

This shows you the differences between two versions of the page.

--- database:oracle [2014/01/07 15:59] – [Useful Commands] tmade
+++ database:oracle [2015/03/02 11:20] – [Checks] tmade
@@ Line 112: / Line 112: @@
   create or replace directory EXP_DIR as '/opt/oracle/ora_data/custx';                #Create or edit export directory
   create or replace directory DATA_PUMP_DIR as '/opt/oracle/ora_data/custx';          #Create or edit data pump directory
-  Select username from dba_users;                                                     #To determine der databaseuser/database schema
+  select username from dba_users;                                                     #To determine der databaseuser/database schema
 ==== Connecting SQL*PLUS with a shell script ====
@@ Line 169: / Line 169: @@
   select OBJECT_NAME, OBJECT_TYPE from dba_objects where OBJECT_NAME like 'V$%';
   select FILE_NAME from DBA_DATA_FILES;                                                                           #Check active tablespaces
+  sql>set linesize 300                                                                                            #Set linesize (lenght) to 300 (max is 32767)
+  sql>spool /tmp/testfile                                                                                         #Output sql-statement into a file "/tmp/testfile "
+  sql>spool off                                                                                                   #Swith off output to file