Partition in Oracle Database from ABAP Coding
I searched the whole day for a suitable answer in sdn, but I could not find one. So please help me. This is my question:
I use SAP BW 3.5 and I want to create partitions automatically for values in one column in the Oracle Database below SAP BW. I know how to do this for the fact-table via BW transaction (rsa1 - administrate cube), but I want to do it for a normal transparent table. There is no chance to do it in the Oracle DB, because DBA denies it because of too much support.
The rule for creation should be "insert a new partition for every single value of this colum. If a partition is not existing so create it". This column is a "version". This should run automatically. I can run ABAP COding everytime before inserting any data into the table. Is there any chance to handle this via Native-SQL or somethin like that?
Is there any chance to do this automatically from SAP via transaction or via ABAP Coding? Any supposes for ABAP Coding?
Thank you very much for help.