Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041 [message #226429] |
Fri, 23 March 2007 12:20  |
t.summerfield
Messages: 39 Registered: March 2007 Location: UK
|
Member |
|
|
Hello
I have recently formatted and setup one of the servers at work (windows server 2003) and have installed Oracle 10g R2 on it. It previously had Oracle 9i
My role in this is as the DBA and as such I have very little SQL experience!
I have a program I use to generate the DB script files and optionally build the databases. The problem I am having is when I check the build output of the scripts - they are riddled with errors; specifically:
ORA-02021: DDL operations are not allowed on a remote database
ORA-30041: Cannot grant quota on the tablespace
I think it is worth noting that these problems were non-existent when using Oracle 9i
In regards to the DDL operations not being allowed on a remote database; I connect with sys as sysdba so I don't think I am lacking the appropriate priviledges? Or is there anything I need to check in the enterprise manager?
And in regards to not being able to grant quota on the tablespace; I check the tablespaces in the enterprise manager and the temp tablespace is present and correctly named. Am I missing the point?
Looking around the web it seems Oracle 10g no longer supports quotas on temp tablespaces - is this the case? And if so is there a simple solution to my problem, or am I going to have to get the developers to change the scripts?
I appreciate these are prob two unrelated problems, however both are giving me grief and I am unable to find a solution. So any suggestions/help would be greatly appreciated.
Feel free to ask questions (I am fairly new to this, and prob could have made things more clear!)
Thanks in advance
Toby
|
|
|
|
Re: Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041 [message #226676 is a reply to message #226429] |
Mon, 26 March 2007 03:10   |
t.summerfield
Messages: 39 Registered: March 2007 Location: UK
|
Member |
|
|
Thanks for the reply Michael.
So why was I not getting the DDL error when I was using Oracle 9i?
Just to reiterate, it is a problem with the sql files rather than the Oracle 10g configuration?
BTW it is the Synonyms that are producing the errors. An example is:
CREATE OR REPLACE SYNONYM &HKCONTROLDB_Schema_Name..KnowledgeGene FOR &HKDB_Schema_Name..KnowledgeGene@&db_name;
GRANT SELECT ON &HKCONTROLDB_Schema_Name..KnowledgeGene TO &HKCONTROLDB_Schema_Name;
COMMIT;
Thanks
Toby
|
|
|
|
|
|
|
|
|
|