Oracle DBA Question:
Download Questions PDF

System tablespace cant be exported from one database and imported into another why?

Answer:

System table space and it's contents are created a part of database creation and contains the meta data of the database. I do not see any reason why one would want to export and import contents only the SYSTEM table space. It can be part of the full database export/import.

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?When using Oracle export/import what character set concerns might come up? How do you handle them?