Differences

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

--- database:oracle [2014/01/07 15:59] – [Useful Commands] tmade
+++ database:oracle [2014/01/27 15:36] – [Useful Commands] tmade
@@ Line 168: / Line 168: @@
   select OBJECT_NAME, OBJECT_TYPE from dba_objects where OBJECT_NAME like 'DBA_%' and OBJECT_TYPE='TABLE';
   select OBJECT_NAME, OBJECT_TYPE from dba_objects where OBJECT_NAME like 'V$%';
-  select FILE_NAME from DBA_DATA_FILES;                                                                         #Check active tablespaces
+  select FILE_NAME from DBA_DATA_FILES;                                                                           #Check active tablespaces
+  sql>set linesize 300                                                                                            #Set linesize (lenght) to 300 (max is 32767)