DataPump is an excellent tool to transfer data between databases. Since Autonomous Databases don’t provide access to their OS there is a difficulty to use datapump to import or export data. This is bypassed by using a storage bucket. To…
To access the Autonomous Database using CloudShell you need to set the following parameters: export ADBID=ocid1….. –This is the OCID of the Autonomous database. export WNAME=wallet.zip —This is the wallet file. export WPWD=password — This is the password of the…
Use the following statement to see all columns covered by indexes on a table:
Use the following query to find the size of a table including its indexes and LOBs.