Re: Cann't create table???(Orcale 7.3.4.0)!!Please Help!

From: John Durst <jdurst_at_sky.net>
Date: Tue, 29 Sep 1998 23:40:04 -0500
Message-ID: <3611B623.F4CA6E73@sky.net>

The message is saying the user doesn't have a sufficient quota for the tablespace, not that the tablespace itself is out of room. You will have to do an ALTER USER x QUOTA bytes/K/M/UNLIMITED ON TABLESPACE ts;

Cincout wrote:

> Where I enter a SQL Command in the SQL*PLUS, I encounter a error message
> as follow.
> I was checked the tablespace 'Trading' containing enough space (50M free
> space in a Data File).
> I am use Oracle 7.3.4.0 on a WinNT 4.0 server. How can I solve the
> problem??
>
> SQL> create table PHYSICAL_DEAL_ID_PRODUCT
> 2 (DELETED VARCHAR2(1),
> 3 DEAL_ID_PRODUCT VARCHAR2(2),
> 4 DESCRIPTION VARCHAR2(50));
> create table PHYSICAL_DEAL_ID_PRODUCT
> *
> ERROR at line 1:
> ORA-01536: space quota exceeded for tablespace 'TRADING'
Received on Tue Sep 29 1998 - 23:40:04 CDT