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

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 25 Aug 2000 14:19:50 -0400
Message-Id: <10600.115582@fatcity.com>

Known bug # 1260483. Use the workaroud of listing up to 50 table names in = the table clause.
I'm not to sure about the max table names in the clause either but thats = what the manual says.
HTH =20
ROR
>>> zmkj04_at_YAHOO.COM 08/25/00 01:03PM >>>
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,
>=20
> I need to import tables data and eliminate all other
> objects from the export
> dump file while importing. I used the following
> parameter file:
>=20
> userid=3Dsystem/Password
> buffer=3D1048576
> file=3D/usr/local/oracle/temp/exp_temp.dmp
> ignore=3Dy
> grants=3Dn
> indexes=3Dy
> rows=3Dy
> commit=3Dy
> log=3D/usr/local/oracle/temp/imp_temp_dsclose.log
> fromuser=3Dbabujd
> touser=3Dbabujd
> tables=3D(*)
>=20
> The parameter tables=3D(*) 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.=20
>=20
> 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
>=20
> 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.
>=20
> 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.
>=20
> Thanks,
> -- Janardhana Babu
> --=20
> Author: Janardhana Babu
> INET: jbdonga_at_ucdavis.edu=20
>=20
> 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!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/=20
--=20
Author: =3D?iso-8859-1?q?Gillian=3D20M?=3D   INET: zmkj04_at_yahoo.com=20

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 Received on Fri Aug 25 2000 - 13:19:50 CDT