Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Interviewing Tips for ERP Consultants and other ERP Jobs topics.
Export-import, CREATE TABLE… AS SELECT, COPY
You should use the ALTER TABLESAPCE… SHRINK command.
The user will be assigned the SYSTEM tablespace as a default and temporary tablespace. This is not good, as it causes user objects and temporary segments to be placed in the SYSTEM tablespace. This results in fragmentation and improper table placement.
DBMS_SHARED_POOL, DBMS_UTILITY, DBMS_SQL, DBMS_DDL, DBMS_SESSION, DBMS_OUTPUT and DBMS_SNAPSHOT.
The index that is automatically generated will be placed in the users default tablespace. This is usually the same tablespace that the table is being created in and will cause serous performance issues.