Database Tools
Discussion List
-
How export schema tables if DB has an APEX workload type?Summary: If DB has an APEX workload type datapump can't be used. Content (required): I read several documents about datapump that is the main way to export data from a s… -
ADB Excel add-in : Installer issueSummary: I am facing issues with installing the Autonomous Database Excel add-in on my Windows machine. As you can see in the attached screenshot, the install.cmd when r…
-
ADB URL for Oracle Autonomous Database Excel add-inSummary: Please can someone provide steps on how to get the specific ADB URL from the admin console. A video of the entire connection setup process with an example would…
-
Is it possible to get Autonomous DB to automatically switch to Daylight Saving Time (such as BST)?Summary: Is it possible to get Autonomous DB to automatically switch to Daylight Saving Time (such as BST)? Content (required): Is it possible to get Autonomous DB to au…
-
Getting Create session priveledge error through sql developerSummary: Getting Create session priveledge error through SQL developer Content (required): Hi All, I have Provisioned an ATP db. instance and when i tried to connect to …
-
Encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATASummary: I am encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATA in a PROCEDURE. Content (required): I'm working on creatin…
-
How to Export and Import a Table/Schema from one DB to other DB in the same tenancySummary: How to Export and Import a Table/Schema from one DB to other DB in the same tenancy Content (required): How to Export and Import a Table/Schema from one Autonom…Srikanth Muramreddy-Oracle 54 views 6 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
The Automatic Backups in Autonomous Database in OCI is of RMAN ?Summary: The Automatic Backups in Autonomous Database in OCI is of RMAN ? If yes, how to confirm it? I tried to check under V$RMAN_BACKUP_JOB_DETAILS table but didn't fi…Srikanth Muramreddy-Oracle 21 views 1 comment 0 points Most recent by Masiuddin Ahmed-Oracle Autonomous Database
-
503 service unavailable errors after creating ATPSummary After creating a new ATP, I try and go to SqlDeveloper for Web or Apex I get a 593 service unavailable error.Content This is the error details after I have creat…
-
ORDS - Issue with OAUTH Implicit grant - Missing or Incorrect Client idSummary: An ORDS client has been created in an ATP database as following. When doing the 1st step of the schema sign-in/authentication get the 400 Bad request message On…
-
Connect to ATP Database from ExcelSummary: Want to connect to ATP Database from Excel Content (required): Hi, Found below note to connect to ATP DB from Excel, but we don't find option to download 'Add-i…
-
ATP in private subnet, how to allow access of APEX & ORDSSummary: Hi Team, We are planning to provision ATP for a client and private subnet, so it will have a private endpoint. so how to do access APEX, ORDS and database actio…
-
IO Error: Mismatch with the server cert DNHello, I am using Oracle Cloud Autonomous Database free tier Summary: When I try to connect using SqlDeveloper I get this error: An error was encountered performing the …
-
UPCOMING WEBCAST: Delivering successful Data Lakes with Autonomous Data WarehouseSummary: WEBCAST with live Q&A: Delivering successful Data Lakes with Autonomous Data Warehouse Date: Wednesday June 7 @ 11:00AM ET / 4:00 PM BST / 5:00 PM CET Registrat… -
WEBCAST - Delivering successful Data Lakes with Autonomous Data WarehouseSummary: WEBCAST with live Q&A: Delivering successful Data Lakes with Autonomous Data Warehouse Date: Wednesday June 7 @ 11:00AM ET / 4:00 PM BST / 5:00 PM CET Content (…
-
ANNOUNCEMENT: February's newsletter covering all the latest new features in Autonomous DatabaseList of all the new features recently added to Autonomous Database (too many to list) in our regular "What's New" newsletter - https://blogs.oracle.com/datawarehousing/p…Keith Laker-Oracle 82 views 2 comments 3 points Most recent by Jayendra G-Oracle Autonomous Database
-
Hi I am facing issue while passing rec array as input parameter in ORDS exposed package procedureSummary: I am facing an issue and not sure about doing it correctly I created a package and created a record type and CREATE OR REPLACE PACKAGE my_test_package AS TYPE t… -
Issue while quering data in object storage using ADWSummary: Hi All, We have stored our parquet files in oracle object storage and have created logical entities in the Oracle data catalog using a file pattern. The data ca…SiddharthDang-Oracle 61 views 3 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database -
Unable to access one of Oracle ADW's user apart from ADMINSummary: Content (required): Hi team, I am unable to access APEX or any Database Actions, using one of customized user's login credentials. It is displaying an error , s…Ankan Chanda 571 views 4 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database
-
Transparent Data EncryptionWe are trying to use Transparent Data Encryption for encrypting columns in Oracle ATP database. we have used the below query for creating a table with encrpted column, b…Narayanan V-Oracle 62 views 4 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database -
Can DBMS_CLOUD.COPY_DATA function picks up all the columns from the target table automatically?Summary: Hi Team, I am trying to load a JSON zipped file placed in Object Storage to a ADW DB Table using the DBMS_CLOUD package. Below is the sample code - DECLARE tabl…Partha Kar-Oracle 102 views 2 comments 0 points Most recent by Partha Kar-Oracle Autonomous Database
-
How to dump data from one ATP database to other ATP databaseSummary: How to dump/Clone data from one ATP database to other ATP database Content (required): We have production ATP database and we want to clone/dump the data from A…
-
Connecting to autonomous database using Jupyter oracledb, getting SSL: SSLV3_ALERT_HANDSHAKE_FAILURESummary: I am attempting to connect to my oracle cloud autonomous database using Jupyter notebook. I downloaded the wallet from Oracle Autonomous page. However, using or…
-
Cannot access Database Actions at Marseille RegionSummary: I get an error message when I press the "Database Actions" button The error message is: "Launch DB actions Failed to auto sign-in. Close this dialog and log-in …
-
Why does my database always free keep stopping every timeI was have new account on OCI, after my Free Tier accounts finished IN the database stop automatically ,and when I start it it's stop within 1 Minute again, and I can't …
-
503 Service Unavailable - ATP Keeps shutting downContent 503 Service Unavailable - ATP Keeps shutting down503 Service Unavailable - ATP Keeps shutting down Have restarted atleast 10 times and it keeps shutting down. Ea…User_2025-02-11-09-37-17-226 37 views 3 comments 0 points Most recent by Sanchit Rastogi Autonomous Database -
How to enable supplemental logging on Autonomous ATP or ADW on Shared InfrastructureSummary: Per the latest documentation, it shows that Goldengate should be able to extract from ATP or ADW. In order for GoldenGate to do this we need to add supplemental…User_2025-02-12-21-26-29-663 361 views 4 comments 0 points Most recent by Masiuddin Ahmed-Oracle Autonomous Database
-
One of my autonomous DB is not listed in the OCISummary: Content (required): I had an 'Always free' autonomous DB (ocid1.autonomousdatabase.oc1.ap-seoul-1.anuwgljrvqohgdyaod27ibh52gzviktqeaaghwl5eq3ywh4757sk7p57xfja) …Cijo M Jose-Oracle 31 views 4 comments 0 points Most recent by Cijo M Jose-Oracle Autonomous Database
-
How do I deal with an ORA-01924 error on my Oracle Autonomous DB?Summary: Error starting at line : 10 in command - GRANT "DBA" TO "ADBSNMP" Error report - ORA-01924: role 'DBA' not granted or does not exist 01924. 00000 - "role '%s' n…User9152064-Oracle 2.6K views 1 comment 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
To insert values from one table to anotherContent Hi team, So there is this table having 4-5 columns in which we will insert the ID and another column name, (say names) , values , into the child table where the …