Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: this shouldn't be happening
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
![]() |
![]() |