Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: tablespace SYSTEM used by others user, not sys. Help!

Re: tablespace SYSTEM used by others user, not sys. Help!

From: x <x_at_x.hr>
Date: Fri, 4 Jun 2004 08:25:27 +0200
Message-ID: <c9p4i6$ndq$1@ls219.htnet.hr> 






>I wonder, how can the table

> created by them is in system schema? Pls let me know, if u have the

> answer.

>




create table my_table (x varchar2(1)) tablespace system



Easy as that. If your dev_user has right priviledges he can create table
where ever he wants.
Received on Fri Jun 04 2004 - 01:25:27 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US