Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export exluding one Tablespace Oracle 9i

973679Nov 28 2012 — edited Nov 29 2012

Hi,

I have to perform an Oracle Export for just five schemas, but one of them I have to exclude a Tablespace.

I made a parfile where I specified all the tables that I want to backup. Something like this.

userid=user1/passwd
file=/myexport/schemas.dmp
rows=y
buffer=10971520
direct=y
statistics=none
indexes=y
tables=('TABLE1',
'TABLE2',
'TABLE3',
'TABLE4',
....
....
'TABLE1206')

I got the name of the tables through a shell scripting dynamic query, so the result is vertical and the export shows me:

"EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help"

My questions are:

Is there any way to exclude a tablespace directly in the export options?

Otherwise:

I tried to make a query that shows me all table names in only one row:

select xmlagg (xmlelement (e, table_name || ',')).extract ('//text()'),','
from dba_tables where owner in ('OWNER1','OWNER2','OWNER3','OWNER4','OWNER5')
and tablespace_name <> 'TSXXX' order by rownum

but I got: ORA-19011: Character string buffer too small

Do you have other ideas?

Thanks!