Always post the oracle release version(4 digits) you're using.
Do we need to create all the partitions before creating the subpartitions within them in oracle tables? If no, then I am trying to add a new partition and subpartition in that but I am not able to do that. I am not getting the proper query for that
Can't I create the partition after creating the table and then subpartition it.why not create the table with partition and subpartitions defined?
Can't I create the partition after creating the table and then subpartition it.Yes, you can. You have two options :