Re: Oracle Designer 6i Error message

A few things.

You can see all that all the requirements have blue check marks and still not have everything set up properly. It is very important to read the installation/migration instructions step-by-step. You should make sure your tnsnames.ora for the target database, the source database (if any) and the repository database all have the same settings. If migrating, Designer will want to set up a link between source and target databases. Make sure your init.ora parameters do not prohibit this. You do not need to create all the index and data tablespaces Designer suggests, but you definitely don't want to put anything unnecessary in the System tablespace.

Van

<garfield_88_at_hotmail.com> wrote in message news:8skib8$1c0$1_at_nnrp1.deja.com...
> Hi Frank,
>
> I grant the CONNECT, RESOURCES, DBA role to Scott
> I follow the instruction on the Oracle Designer and grant other
> privilieges and repository role to scott too. I use the Designer
> Utility to check the requirement and it shows Scott has been grant all
> the privileges required for designer. Then I use the Designer Utility
> to create the Repository and in the SYSTEM tablespace. In the
> documentation, Oracle suggest to create many tablespace such as
> rapid_grow_indexes, rapid_grow_tables, VERSION_TABLES, TEMPORARY_TABLES
> etc. Do I really need to create all these table spaces and create a new
> user to use this table spaces and create the reposity in there? Or I
> can just use an existing user like Scott and create the Repository in
> the SYSTEM or USER tablespace. Is this related to the error
> message, "no workarea"? The error code is CR2034 something, I double
> check with it again.
>
>
> In article <39ECBB6E.C08B331E_at_home.nl>,
> frank <fbortel_at_home.nl> wrote:
> > Is this even before adding a work area?
> > Did you grant the privs listed in the install guide directly to scott?
> > Not to a role, and grant that role to scott?
> > What do you mean by "all priveleges from sys to scott".
> > What's the error code?
> >
> > garfield_88_at_hotmail.com wrote:
> >
> > > I have installed Oracle Designer 6i and create a repository using
 the
> > > Scott user and I have granted all the priviles to Soctt from the Sys
> > > user. I also have Oracle 8i installed on the same machine. When I
 open
> > > Designer 6i. I got the following error:
> > > Non-versioned repository has no workarea or insufficient privileges.
> > > Anyone can help me to fix the problem. Thank you.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 19 2000 - 00:43:32 CEST