Home » SQL & PL/SQL » SQL & PL/SQL » creation of Schema
icon5.gif  creation of Schema [message #207118] Mon, 04 December 2006 03:50 Go to next message
inforacle
Messages: 21
Registered: December 2006
Junior Member
Hai ,
thanks can anybody tell me how to create a new schema.

clear me
1.Does schema means user?
Re: creation of Schema [message #207126 is a reply to message #207118] Mon, 04 December 2006 04:16 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You want to use the CREATE USER statement. Each user comes with a schema of the same name.
Re: creation of Schema [message #207130 is a reply to message #207126] Mon, 04 December 2006 04:20 Go to previous messageGo to next message
inforacle
Messages: 21
Registered: December 2006
Junior Member
fine, if i create a new user can i get the default tables present in scott user.

if not how can i copy the tables from one user to another user.
Re: creation of Schema [message #207137 is a reply to message #207130] Mon, 04 December 2006 04:46 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this recent topic about Scott's tables.
Re: creation of Schema [message #207173 is a reply to message #207130] Mon, 04 December 2006 07:11 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I think you may misunderstand the nature os the Scott tables. They are not a set of default tables that get created with a new schema - they are a set of demo tables created by a script, whose role is to be the basis of a tutorial in basic SQL
Previous Topic: Converting rows into column
Next Topic: How to print (v)array (merged)
Goto Forum:
  


Current Time: Sat Dec 03 17:54:27 CST 2016

Total time taken to generate the page: 0.12231 seconds