I have 300gb of data to be loaded in a single table. It pulls from one another table from the same db and does some manipulation and sorts and then load into this table.
My questions are:
1) Do I need to have 300gb of undo tablespace and 300gb of temp tablespace to accommodate the load?
2) What would be the other things like db parameters, online redo log numbers and size to be considered?