I want to refresh multiple schemas with datapump, whats the best way I should drop the existing schemas, objects or I can use any parameter in the import script.
If I need to drop how can I drop schemas or objects with the help of shell script.
- you can use EXPDP with CONTENT=METADATA_ONLY option for getting only database object definitions. no data is included see further in the link:
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…