From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Where are these tables?? |
Date: | 2004-03-26 14:28:31 |
Message-ID: | OFC3BFFCF6.47BC2B3A-ON88256E63.004F83D6-88256E63.004F8411@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2><DIV> </DIV><DIV><DIV>While trying to find the physical disk space size each table in our database (by matching the file name in the base directory to an entry in pg_class), we found 4 files that constitute 5gigs that we cannot match back to a entry in pg_class.</DIV><DIV>Is it safe to delete these? </DIV><DIV> </DIV><DIV>TIA<br>Patrick Hatcher<br></DIV></DIV></FONT>
>From pgsql-general-owner(at)postgresql(dot)org Fri Mar 26 10:43:49 2004
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.2])
by svr1.postgresql.org (Postfix) with ESMTP id A11EFD1BA68
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Fri, 19 Mar 2004 11:24:14 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
with ESMTP id 53712-01
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Fri, 19 Mar 2004 07:24:15 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
by svr1.postgresql.org (Postfix) with ESMTP id 9BDE9D1E94C
for <pgsql-general(at)postgresql(dot)org>; Fri, 19 Mar 2004 07:24:12 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
by news.hub.org (8.12.9/8.12.9) with ESMTP id i2JBOA1Y086882
for <pgsql-general(at)postgresql(dot)org>; Fri, 19 Mar 2004 11:24:10 GMT
(envelope-from news(at)news(dot)hub(dot)org)
Received: (from news(at)localhost)
by news.hub.org (8.12.9/8.12.9/Submit) id i2JAx4M4082819
for pgsql-general(at)postgresql(dot)org; Fri, 19 Mar 2004 10:59:04 GMT
From: chanc(at)thailand(dot)net (chanc)
X-Newsgroups: comp.databases.postgresql.general
Subject: Does ora2pg work with Oracle9i?
Date: 19 Mar 2004 02:58:55 -0800
Organization: http://groups.google.com
Lines: 17
Message-ID: <d0551d45(dot)0403190258(dot)69b3e494(at)posting(dot)google(dot)com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse(at)google(dot)com
To: pgsql-general(at)postgresql(dot)org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/934
X-Sequence-Number: 58978
I got this kind of error message when trying to copy out from
Oracle9i.
[Red Hat 8.0, Oracle9i Release 2, DBI-1.42, DBD-Oracle-1.15,
DBD-Pg-1.32, ora2pg-2.1]
DBD::Oracle::db prepare failed: ORA-00942: table or view does not
exist (DBD ERROR: error possibly near <*> indicator at char 46 in
'SELECT COUNTRY_ID,COUNTRY_NAME,REGION_ID FROM <*>COUNTRIES') [for
Statement "SELECT COUNTRY_ID,COUNTRY_NAME,REGION_ID FROM COUNTRIES"]
at Ora2Pg.pm line 1321.
Can't call method "errstr" on an undefined value at Ora2Pg.pm line
1321.
Does anyone successfully use ora2pg to copy data from Oracle9i?
Regards,
Chanc
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 2.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Lee Tucker | 2004-03-26 15:26:16 | Passing a row |
Previous Message | Anony Mous | 2004-03-26 14:28:11 | Re: pg_dump "what if?" |