Thinking SQL
Thinking SQL
HannieTo restore a database from the default directory /backup/rman use the cmd
Instead of restoring the full database, you can also restore only specific tablespace
cmd:RMNAN> RESTORE TABLESPACE dev1;
Here dev1 is the tablespace name
To restore more than one tablespace by separating them with commas.
cmd:RMNAN> RESTORE TABLESPACE dev1, dev2;
HannieIts a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive tool as it displays changes…
HannieIn normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present until a VACUUM is done. Therefore it’s necessary to do VACUUM periodically, especially…
