Home

CREATE OR REPLACE VIEW ORA-01031

Hello, I am trying to run a long sql script that creates tables, triggers and procedures etc. I ran the same script on 9i some time ago and it worked OK - but 10G barfs on CREATE OR REPLACE VIEW as follows: DROP USER getreports CASCADE; CREATE USER getreports IDENTIFIED BY getreports DEFAULT TABLESPACE getreports

full article | source