New answers tagged

0

You cannot put the datafiles in Offline when your DB is in No Archive Log mode. So below are the steps to recover the database considering current situation : Shutdown immediate; startup nomount; Recreate the control file using backup trace. : alter database backup controlfile to trace as '$ORACLE_HOME/dbs/control_new.sql'; Now make changes in the ...


1

The following solution allows for storing/retrieving blobs externally, avoiding any duplications, stored in a tree of folders and files named after the blobs' own md5 hashes, in such a way the can be queried and manipulated as if they were simple database bytea columns. All files are stored in the folder $PGDATA/extstore. Documents are saved to ...



Top 50 recent answers are included