I am in a pickle I need to copy a RAC ASM oracle 10g database from a linux box to a different linux server.
I have been advised that the simpliest method is to shutdown the database then copy the files. I have no problem doing this as I have done this many time before with a single NON RAC database in the past.
I found this to be a problem firstly because ASM makes the files invisible so I have found out how to sort this by using FTP and setting up a port.
Secondly when I shutdown the database and the instances I loose my FTP connection
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…