ok, I think I understand what is going on. I now doubt that $ORACLE_HOME/assistants/dbca/templates/example01.dfb is a copy of a database file. What is it? bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $ ls -la $ORACLE_HOME/assistants/dbca/templates/example01.dfb -rwxr-xr-x 1 oracle dba 13115392 Jun 27 2006 /h/oracle/product/10r2/assistants/dbca/templates/example01.dfb* bash sol oracle ~/product/10r2/assistants/dbca/templates 68 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 68 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 68 $ It is probably a binary file which DBCA can convert into a database file once DBCA knows which characterset lives inside the target database. The transportable tablespace feature depends on a matching of charactersets between the transported data file and the target DB. -Owen On 9/15/07, Owen Smith <owensmith99@xxxxxxxxx> wrote: > 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