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

From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Fri, 25 Aug 2000 09:43:29 -0700
Message-Id: <10600.115572@fatcity.com>

I raised a tar with oracle and they told me it is a bug in 8.1.6 (64 bit) and has been fixed in 8.1.7. Bug# 1260483. This works fine in 8.1.5 and below including 7.3.3.

Thanks,
-- Janardhana Babu

-----Original Message-----
From: Gillian M [mailto:zmkj04_at_yahoo.com] Sent: Friday, August 25, 2000 10:04 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Tables=(*) not working in 816 while importing ...

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!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

-- 
Author: =?iso-8859-1?q?Gillian=20M?=
  INET: zmkj04_at_yahoo.com

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 - 11:43:29 CDT