Re: Create Tablespaces

From: Rob Zwartjes <rzwartje_at_rob.home.nl>
Date: 2000/06/22
Message-ID: <slrn8l4r9j.8eo.rzwartje@rob.home.nl>#1/1

On Wed, 21 Jun 2000 18:10:40 GMT, schmidm_at_kta95.com <schmidm_at_kta95.com> wrote:
>I have created a tablespace using the system account. i have created a
>user. I want the user to be able to create tables in the tablespace,
>but I keep getting the error ORA-01950 - no privileges on
>tablesapce '<name>'. I granted DBA priveleges to this user, but I
>still get this error.

I am also a beginner and ran into the some problem. After searching through a lot of pdf docu. I found out that you can give the user a default tablespace name. It goes like this :

	create user .... ( this part you already have done )
	default tablespace < your created tablespace name >
	temporary tablespace temp;

	grant connect, resource to <user>;

I hope this will help you.
Maybe the guru's here disagree with me :) If so, I will read there comments thoroughly and learn from it.

Rob. Received on Thu Jun 22 2000 - 00:00:00 CDT