Design Tuning IBM DB2 MySQL Oracle SQL Server

define schema='schema_name'
create user &schema identified by password;
/* no "create session" privilege for schema */
alter user &schema
quota unlimited on tspname1​
quota unlimited on tspname2;


back to top

Last updated Wednesday March 7, 2007

Printer-friendly PDF* format:

Create Schema

Oracle DDL

This Section

You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.