Recreating full schema tablespace/datafiles
I have a particular schema that I would like to drop both index and data tablespaces and recreate all their datafiles. I plan to use datapump to do a schema export/import. I have verified that all segments (via dba_segments) in these tablespaces are owned by a single schema account and this account does not own any segments outside of these tablespaces. I am concerned that completely dropping the tablespaces and contents, then reimporting the datapump file may not recreate all necessary database entities (ie public grants, sequences, packages, etc).
Can you please verify if these are the proper steps and whether or not anything is missing:
Can you please verify if these are the proper steps and whether or not anything is missing:
0