Oracle Database
Have your database size
If you’d like to know how big your DB is: select FILE_NAME, d.TABLESPACE_NAME, d.BYTES datafile_size, nvl(sum(e.BYTES),0) bytes_used, round(nvl(sum(e.BYTES),0) / (d.BYTES), 4) * 100 percent_used, d.BYTES – nvl(sum(e.BYTES),0) bytes_free from DBA_EXTENTS e, DBA_DATA_FILES d where d.FILE_ID = e.FILE_ID (+) group by FILE_NAME,d.TABLESPACE_NAME, d.FILE_ID, d.BYTES, STATUS order by d.TABLESPACE_NAME,d.FILE_ID
Export script – beginners
Here is a very simple script to save an Oracle database with a full export script. It’s a very basic example, because there is no log and no option (only a full export) Ina few days i’ll post a more detailled export script. #!/bin/bash #—————————# # Oracle Full export script # # Nuxora v1.0 # [...]
Working with TAF – Transparent Application Fail-Over
I’ll try to write a tutorial on TAF, it seems to be very efficient but i’ve never really used it in real condition, just test. If you want to connect to TAFTEST, first it will try ton connect to NUXORA01, if something’s wrong it will try to connect to NUXORA02 DBPROD = (DESCRIPTION_LIST = (DESCRIPTION [...]
Import / export sous Oracle
L’export constitue une méthode simple pour sauvegarder une base ou pour la deplacer, il faut toutefois garder à l’esprit que l’export doit etre consistant, il n’y doit pas y avoir demodifications sur la base au cours d’un export. Pour le réaliser, il faut d’abord créer un utilisateur nommé import ou export ou impexp CREATE USER [...]
