Topic : Transportable Tablespace

Before a DBA creates a transportable tablespace; which condition must be completed?


  • All indexes are disabled or dropped.
  • The target system has precreated the tablespace.
  • The target system is in the same operating system.
  • The tables containing nested tables are contained in the same tablespace.

Answer :

The target system is in the same operating system.

Show Answer Discuss

Can we transport tablespace from one database to another database which is having SYS owned objects?


  • Yes
  • No

Answer :

No

Show Answer Discuss

What is default value for TRANSPORT_TABLESPACE Parameter in EXP?


  • Yes
  • No

Answer :

No

Show Answer Discuss

How to find whether tablespace is created in that database or transported from another database?


  • V$database
  • Dba_tablespaces
  • Dba_data_files
  • V$transport_tablespace

Answer :

Dba_tablespaces

Show Answer Discuss

Can we Perform TTS using EXPDP?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss