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

Home -> Community -> Usenet -> c.d.o.misc -> Re: this shouldn't be happening

Re: this shouldn't be happening

From: Richard <richwerth_at_hotmail.com>
Date: 5 Oct 2001 11:31:18 -0700
Message-ID: <44160353.0110051031.5c820b10@posting.google.com>


sfitzgerald_at_centurytel.net (Sean Fitzgerald) wrote in message news:<605a2fd5.0110040819.3d965711_at_posting.google.com>...
> At first glance my comment is don't put application tables in the sys
> schema. SYS is for the data dictionary. You should create separate
> tablespaces for your application as well as separate owners.
> Otherwise you are asking for big trouble with fragmentation and
> security.

Thanks everyone for a speedy response the issue has been solved. Um developer error? :)

anyway we just wanted to quickly get an env up and running for proof of concept. Once this app is working the tables and the user will be changed. We get an F for best practice I guess. Received on Fri Oct 05 2001 - 13:31:18 CDT

Original text of this message

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