The main table is linked with many child tables using foreign key. And need to add the list partition in the main table but i want all child table will also be linked with this partitioned table. There are many indexes already defined. Please guide how can i do that?

I’m trying to delete a large number of rows from a table, but parallelism isn’t fully working and the execution plan Note says “PDML disabled because array binds are used”. How can I fully enable parallelism for these SQL statements?

I call DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL in different configuration and users. At my personel computer, it works well. below code assigns start_id to 1.
But at business computer, it can not assign START_ID. I mean START_ID is null. I think there is a missing Grant.

I have a table with colums and data as follows

I created a record and a table of records on the db schema the following way :

Closed yesterday.

I have a table which stores Hierarchy of Customers i.e., GrandParent, Parent and Child as follows

I have a table which stores Hierarchy of Customers i.e., GrandParent, Parent and Child as follows

I’ve been looking at my code for a while and searching for any syntax errors that may be causing the problem but I really can’t find it anywhere. I’m running the script in Oracle Autonomous Database and tried it on the Live SQL but it won’t run on both.

I have below PLSQL query returning me some list of timestamps based on input range of timestamps.