Re: Importing data into Personal Edition

You have to create the user under oracle, then grant connect, resource before you do an import.

create user blah identified by blah default tablespace users temporary tablespace temp;

grant connect, resource to blah;

Then you can import, the only way you can import without user created is if you are doing a "FULL" db import.

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
>
>

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


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