Re: Need help for importing from old to new database

In article <3hnuae$rvr_at_sophia.inria.fr>

           boudot_at_tlaloc.inria.fr "Marianne Boudot" writes:

> when I look at the exported file, I can see for instance the statement
> " create tablespace "toto" datafile
> 'physical_path_ot_the_tablespace_file_on_the_old_database'..."
> and so on.
>

If you run the import with listonly=y and indexfile=y you will be able to create a file in ASCII format with only the CREATE_TABLE commands etc. You can then edit this file and alter the physical information to your test DB requirements. If you then run this command file all the required objects will then be created. Then just run a normal import of the original file with the option to ignore create errors and this should do the trick.. Hope this helps ......

-- 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
keith taylor                         |   Northumberland County Council
Database Administrator               |   Computer services
email: keith_at_northlnd.demon.co.uk    |   County hall
voice: (01670) 533294                |   Morpeth
Fax  : (01670) 533330                |   Northumberland.
                                     |   NE61  2EF.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++