Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Question about creating user and tablespace with Oracle 9.0
In Oracle 8.1.7, our application create users with those commands:
Script:
CREATE TABLESPACE USER_DATA ONLINE PERMANENT;
Hard coded:
CREATE USER <USER> IDENTIFIED BY <PWD>;
ALTER USER <USER> DEFAULT TABLESPACE USER_DATA;
ALTER USER <USER> TEMPORARY TABLESPACE USER_DATA;
The same hard coded command doesn’t work in 9.0.
The message is that a permanent table space cannot be used as temporary.
When I create the tablespace USER_DATA as following: CREATE TABLESPACE USER_DATA ONLINE TEMPORARY; We get the message that a default tablespace cannot be temporary. We don’t have the source code to modified the hard coded section. Is there a solution…. Received on Fri Oct 05 2001 - 14:05:49 CDT