Re: Exporting a partition with transport tablespace

[Arup Nanda]

Title: Exporting a partition with transport tablespace

No it's not. However, you could simply exchange the partition with a table and then export the tablespace.   For instance,   ALTER TABLE HISTO_DOSSIER EXCHANGE PARTITION part1 WITH TABLE HISTO_DOSSIER_part1;   Then export the tablespace. Make sure you do the same for any local indexes, too.   HTH.   Arup Nanda ----- Original Message ----- From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Monday, December 22, 2003 10:34 AM Subject: Exporting a partition with transport tablespace Hi list, is it possible to export a partition with the transportable tablespace feature ? My partition is over 8 Go. Here my statements , thank you in advance ! SQL>exec sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE); SQL> select * from sys.transport_set_violations; VIOLATIONS -------------------------------------------------------------------------------- Partitioned table TOPASE.HISTO_DOSSIER is partially contained in the transportab le set: check table partitions by querying sys.dba_tab_partitions Default Partition (Table) Tablespace HISTO_DOSSIER_P2_MD_TAB for HISTO_DOSSIER n ot contained in transportable set Default Partition (Table) Tablespace HISTO_DOSSIER_P3_MD_TAB for HISTO_DOSSIER n ot contained in transportable set Default Partition (Table) Tablespace HISTO_DOSSIER_P4_MD_TAB for HISTO_DOSSIER n ot contained in transportable set