Did I ... put the tbs in R/O mode before copying? I assume it was. The tbs was created by Oracle. If you have a copy of 10gR2, you will find both the datafile and .dmp file here: $ORACLE_HOME/assistants/dbca/templates/ I did try this: tts_owners=(HR,IX,OE,PM,SH) Result: ORA-19721: Cannot find datafile with absolute file number 5 in tablespace EXAMPLE I'm getting some good clues here. Keep them coming! Thanks, -Owen On 9/15/07, Ghassan Salem <salem.ghassan@xxxxxxxxx> wrote: > Owen, > did you put the tbs in R/O mode before copying? > rgds > > On 9/15/07, Owen Smith <owensmith99@xxxxxxxxx> wrote: > > > > David, > > Thanks for checking my work. > > > > datafiles is a valid keyword. I do have "datafiles" in my command line. > > > > Unfortunately, datafile is not a valid keyword: > > > > > > bash sol oracle ~/product/10r2/assistants/dbca/templates 37 $ > > bash sol oracle ~/product/10r2/assistants/dbca/templates 37 $ > > bash sol oracle ~/product/10r2/assistants/dbca/templates 37 $ imp > > transport_tablespace=y file=example.dmp > > datafile=/h/oracle/oradata/orcl/example01.dfb tablespaces=EXAMPLE > > tts_owners=HR,IX,OE,PM,SH > > LRM-00101: unknown parameter name 'datafile' > > > > IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help > > IMP-00000: Import terminated unsuccessfully > > bash sol oracle ~/product/10r2/assistants/dbca/templates 38 $ > > bash sol oracle ~/product/10r2/assistants/dbca/templates 38 $ > > > > I checked the link you give at oracle-base. > > > > My command line patterns with the command line there. > > > > Unfortunately, the demo there is for 9i. My DB is 10gR2. > > > > Help anyone? > > > > -Owen > > > > > > > > On 9/15/07, David Sharples <davidsharples@xxxxxxxxx> wrote: > > > you missed out the datafile keyword in the import command > > > > > > http://www.oracle-base.com/articles/9i/TransportableTablespaces9i.php > > > > > > > > > On 15/09/2007, Owen Smith <owensmith99@xxxxxxxxx> wrote: > > > > > > > > Hello Oracle People, > > > > > > > > I'm trying to figure out how to import a transportable tablespace I > > found. > > > > > > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > -- //www.freelists.org/webpage/oracle-l