Re: creating a user with permit to create
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 26 Jun 2004 21:49:23 +0200
Message-ID: <tnkrd09auipln68h02mfu0hstc5rip6sec_at_4ax.com>
Date: Sat, 26 Jun 2004 21:49:23 +0200
Message-ID: <tnkrd09auipln68h02mfu0hstc5rip6sec_at_4ax.com>
On Sat, 26 Jun 2004 12:54:26 +0200, "Inki" <inkimar_1968_at_hotmail.com> wrote:
>Hello,
>
>(1)
>creating a new user so that I can import a .dmp file that creates tables.
>Did create a user from 'oracle enterprise manager' with admin privileges,
>but i am denied to import with C:> imp .
>how come ? So I did the import using user system, works fine.
>
>(2)
>Am I able to use toad to see how my tables are linked with relation to one
>and other ?
>Possible to see the design of the db that I am importing ?
>I do lack the book 'programming oracle, triggers and stored procedures' by
>kevin owens
>where the design is described.
>
>regards, i
>
- Grant the user import the imp_full_database privilege
- The full version of Toad has an E/R diagrammer. The diagrammer assumes you have PK and FK relationships in your tables, it doesn't reverse engineer them.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Jun 26 2004 - 21:49:23 CEST