Re: Wildcard in export/import

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 08 Jul 1999 21:05:53 +0800
Message-ID: <3784A231.6DBF@yahoo.com>

Torben Nyman Nielsen wrote:
>
> Hi all,
>
> I am looking for a method to import/load tables from a backup/export with
> wildcard. Is there a import/export/load/unload utility that accepts wildcard
> in table name.
> Example: EXP80 .....
> TABLES=OAS-*
>
> Thanks in advance
>
> Torben Nyman Nielsen

No - but you could use SQL to build your parameter file on the fly...

eg

spool blah
select table_name || ','
from user_tables
where table_name like 'OAS%'
spool off

and then use this...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 08 1999 - 08:05:53 CDT