Ask a Question related to Oracle Server, Design and Development.
-
Mathias Kluge #1
I have a problem to create a constraint referencing table in another schema
Hallo,
the begin of the problem is, i will migrate the structure of a Sybase
Adaptive Server Anywhere Database into ORACLE 8i(8.1.7)Personal
Edition. On the Sybase DB exist 2 users. This users a contained all
tables. One of that are calling "DBA". That user was my first problem
on 8i. I must delete the role "DBA" to craete a user "DBA". Is it a
problem, when the role "DBA" not exist?
After that, i can create all tables with little adaptations on the
column names and datatypes. When i will create a references from the
schema "DBA" to another called "Heiko", i become the 'ORA-01031 -
insufficient privileges' Error Message. The User "DBA" and "Heiko"
have all system privileges.
What is my problem? Who can help me?
Thanks.
Mathias
Mathias Kluge Guest
-
Inconsistent error with create table statement containing foreign key constraint
Here is the clause defining a foreign key constraint. CONSTRAINT `contact_id_fk` FOREIGN KEY (`contact_id`) REFERENCES `conts` (`contact_id`) ... -
Referencing the Table Name
Say I have a Table called Predator: country(varchar 20), animal(varchar 20) And I want to search for the animal "Python" in my Predator table,... -
CREATE TABLE problem
I have a problem creating mySQL tables with PHP. I am making an app where a user can create a project. Pressing "submit" on proj_form.php goes to... -
create table and schema privileges
Hi If I create table as instance owner as follows: create table someuser.junk(x int) What privileges will someuser have. I just tested that... -
Best way to create this constraint?
I need to enforce a simple validation rule on my table. The solution I came up works, but seems complex. Im hopping there is a better way to do this... -
Peter van Rijn #2 Re: I have a problem to create a constraint referencing table in another schema
[1] removing the DBA role is not necessarily a problem, you could could
create similar roles yourself
[2] to be able to reference a table you (i.e. the table owner) need to grant
the REFERENCES privilege to the user that needs it.
hth,
Peter
"Mathias Kluge" <software@dgateway-ger.com> schreef in bericht
news:263641f3.0212090704.453736a0@posting.google.c om...> Hallo,
>
> the begin of the problem is, i will migrate the structure of a Sybase
> Adaptive Server Anywhere Database into ORACLE 8i(8.1.7)Personal
> Edition. On the Sybase DB exist 2 users. This users a contained all
> tables. One of that are calling "DBA". That user was my first problem
> on 8i. I must delete the role "DBA" to craete a user "DBA". Is it a
> problem, when the role "DBA" not exist?
>
> After that, i can create all tables with little adaptations on the
> column names and datatypes. When i will create a references from the
> schema "DBA" to another called "Heiko", i become the 'ORA-01031 -
> insufficient privileges' Error Message. The User "DBA" and "Heiko"
> have all system privileges.
>
> What is my problem? Who can help me?
> Thanks.
> Mathias
Peter van Rijn Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
