Re: Tables=(*) not working in 816 while importing ...

From: Gillian M <zmkj04_at_yahoo.com>
Date: Fri, 25 Aug 2000 08:53:28 -0700 (PDT)
Message-Id: <10600.115569@fatcity.com>

As far as I know, IMPORT does not accept a wildcard. You must list the table names separated by a comma.

If this is an option, great - I'll use it.

G!
--- Janardhana Babu <jbdonga_at_ucdavis.edu> wrote: > Dear list,
>
> I need to import tables data and eliminate all other
> objects from the export
> dump file while importing. I used the following
> parameter file:
>
> userid=system/Password
> buffer=1048576
> file=/usr/local/oracle/temp/exp_temp.dmp
> ignore=y
> grants=n
> indexes=y
> rows=y
> commit=y
> log=/usr/local/oracle/temp/imp_temp_dsclose.log
> fromuser=babujd
> touser=babujd
> tables=(*)
>
> The parameter tables=(*) is not working for me. The
> message in the logfile
> is: import completed successfully without warnings.
> Actually no tables are imported. The DB is
> 8.1.6.0.0(64bit) on HP-UX(11.0
> 64bit). I tried using \(*\), (\*), *, \* etc etc.
> but no success.
>
> The logfile contents are as follows:
>

---

> ****************
> Connected to: Oracle8i Enterprise Edition Release
> 8.1.6.0.0, 64 bit -
> Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> Export file created by EXPORT:V08.01.06 via
> conventional path
> import done in US7ASCII character set and US7ASCII
> NCHAR character set
> Import terminated successfully without warnings.
>

---

> ****************
> If I do the same experimetation on 815(64bit) on
> HP-UX(64bit), it works fine
> and all the tables are imported.
>
> To workaround the problem, I imported in user mode
> and dropped all the other
> objects except tables and indexes. I need to do this
> many times. If anyone
> knows the solution, please let know. It would be
> appreciated.
>
> Thanks,
> -- Janardhana Babu
> --
> Author: Janardhana Babu
> INET: jbdonga_at_ucdavis.edu
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

---

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).

---

Do You Yahoo!? Received on Fri Aug 25 2000 - 10:53:28 CDT