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.
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?
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?
It appears to be complaining about the command line; which you neglected to actually post.
00019, 00000, "failed to process parameters, type 'EXP HELP=Y' for help" // *Cause: Invalid command-line parameters were specified. // *Action: Check the online help screen for the set of valid parameters, then // retry.
970676 wrote:I am unaware of any limit, but such a limit could exist.
I've reduced the number of tables in the export and it was successful.
Actually my list has 1376 tables, so do you think Oracle 9i has a limit of tables to export in the "tables" option?