I will ask them to send me the tablelist with the dump file - I think this is the easiest way. thank you all! On Tue, Dec 1, 2009 at 4:42 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>wrote: > You have to “specify FULL=Y or provide FROMUSER/TOUSER or TABLES “ with > the import command in addition to show=y just as the error indicates. > > > > But, wouldn’t it be easier to just generate the truncate script with a > query on the source database like this: > > > > select ‘truncate table ‘ || table_name || ‘;’ from dba_tables where <insert > desired filter conditions here>; > > > > Regards, > > Brandon > > > > ------------------------------ > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed > by it. >