database:oracle
 
Trace:

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
database:oracle [2014/01/07 15:59] – [Useful Commands] tmadedatabase:oracle [2014/01/27 15:38] – tmade
Line 169: Line 169:
   select OBJECT_NAME, OBJECT_TYPE from dba_objects where OBJECT_NAME like 'V$%';   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)
 +  sql>spool /tmp/testfile                                                                                         #Output sql-statement into a file "/tmp/testfile "
 +  sql>spool off                                                                                                   #Swith off output to file
  
database/oracle.txt · Last modified: 2017/12/09 01:19 by 127.0.0.1
 
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki