Re: Importing data into Personal Edition

You can always create a db link then do a:

CREATE TABLE blah

    AS SELECT *
         FROM origblah_at_dblink;

In article <8rfvg9$efj$1_at_nnrp1.deja.com>,   yszhang_at_my-deja.com wrote:
> I used to tried exp from o804 and imp to o734, even follow oracle's
> document run some dbms scripts, it never work for me. Then I found
> database copy can do the work for me, using copy command in sqlplus to
> copy table from o804 to a temp. table in o734.
> but my machines are all in network, and I only need a table, Im not
 sure
> it can help or not.
> ys
>
> In article <OGF43chLAHA.328_at_cpmsnbbsa09>,
> "Ling" <circetsui_at_email.msn.com> wrote:
> > Hi all,
> > I have exported my Oracle 8i database from a NT server and tried to
 import
> > the database into Oracle 8.04 personal edition on Windows ME.
> > The personal edition already has an localized database created when
 it
> > installed. I were getting message saying that the table owner user
 id
> > didn't exist, and many other messages also. So I created the table
 owner
> > user account and tried again. Still didn't work. Anybody has done
 this
> > before?
> >
> > Thanks in advance
> >
> > Ling
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Christopher R. Spence
OCP, MCP, MCSE, A+, RAPTOR, CNA


Sent via Deja.com http://www.deja.com/
Before you buy.