Xref: alice comp.databases.oracle.tools:28533
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: hansqiao@my-deja.com
Newsgroups: comp.databases.oracle.tools
Subject: exp limitation in Oracle 7
Date: Sat, 17 Jul 1999 18:20:42 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 39
Message-ID: <7mqhhj$gg9$1@nnrp1.deja.com>
X-Article-Creation-Date: Sat Jul 17 18:00:22 1999 GMT
X-Http-User-Agent: Mozilla/4.5 [en] (WinNT; I)
X-Http-Proxy: 1.0 x21.deja.com:80 (Squid/1.1.22) for client 170.140.251.129

Hello,

Recently I tried to use exp on Oracle 7.2.3 to
export
a list of 3000 tables. exp failed, saying it
cannot
handle so many tables. So

(1) What is the limit of number of tables for exp
(or
expst) on Oracle 7.2.3 ?

(2) What about the limit for Oracle 8 ?

(3) Can I use exp from Oracle 8 to export in
Oracle 7
?

(4) Is there a limit for imp on Oracle 7 or 8 ?

(5) any alternative way to get around the limit
other than breaking the list of tables into pieces
?

I am currently using Solaris 2.6.

I appreciate your prompt help.

Please send answer directly to
        hansq@hotmail.com

Hans





Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.