> We want to move application data from one database to another. However, > in the > new database we want to change the tablespace names so that they follow > a new naming convention. What is the easiest/most efficient way of doing > this? ... and if you don't match some of the cases below(check the manuals for your Oracle version): 'If LOB data resides in a tablespace that does not exist at the time of import or the user does not have the necessary quota in that tablespace, the table will not be imported. Because there can be multiple tablespace clauses, including one for the table, Import cannot determine which tablespace clause caused the error. ' 'All objects from that tablespace will be imported into their owner's default tablespace with the exception of partitioned tables, type tables, and tables that contain LOB or VARRAY columns or index-only tables with overflow segments. Import cannot determine which tablespace caused the error. Instead, you must first create a table and then import the table again, specifying IGNORE=Y.' Cheers Dimitre -- http://www.freelists.org/webpage/oracle-l