Re: How to change default tablespace of self

Praveen, Do both set of create table scripts create tables under the same or different owners? If the owners are different then either the create any table privilege will be needed or the scripts should be ran as the owner. If the scripts are ran as the owner and the target tablespaces are the default tablespaces for the owners then only the owner ID and passwords are necessary to create the tables correctly. The owner's ID's should then have the necessary privileges rather than you.

If the target db is a production environment why isn't the DBA the person applying the scripts?

IMHO -- Mark D Powell -- Received on Sun Oct 16 2005 - 12:30:20 CDT