Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to create a schema object

HPADM
Advisor

how to create a schema object

Hi,
I'm quite new to oracle.
I created a database with dbassist.
Now I would like to create a schema object for a database user.
Is it easy and possible?
Could you tell me how to do it?
Thank you
5 REPLIES
Christian Gebhardt
Honored Contributor

Re: how to create a schema object

Hi
what object? Check Oracle-Manual-->SQL-Reference
there are about 30 create statements with thousands of options to create a schema object.

Example
- connect to database:
sqlplus user@database
- create table mytable (col1 number);

Creates a table with one column name col1, this column is a number field.

Chris
John Palmer
Honored Contributor

Re: how to create a schema object

Hi,

The first thing to do would be to create an Oracle user to be the schema owner...

create user ??? identified by password...;

Then other objects such as tables and indexes.

Packaged applications come with SQL scripts that create all the required database objects.

Regards,
John
HPADM
Advisor

Re: how to create a schema object

Hi jonh!
I created the user with:

create user "andrea" profile "DEFAULT" identified by "londra"
default tablespace "PROVA_TB" temporary tablespace "TEMP" account unlock;

grant unlimited tablespace to "andrea";
grant "CONNECT" to "andrea";
grant "RESOURCE" to "andrea";

Now, what can I do?

Graham Cameron_1
Honored Contributor

Re: how to create a schema object

>> Now, what can I do?

1. Buy a book
2. Get some training.
3. Visit http://docs.oracle.com/cd_a87860/doc/index.htm (oracle8i) and look at all the CREATE options.
4. cd $ORACLE_HOME/rdbms/demo and peruse the examples, eg o8idemo.sql
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
T G Manikandan
Honored Contributor

Re: how to create a schema object

Schema objects include tables, views, sequences, stored procedures, synonyms, indexes,etc

you have already created the tablespaces and users.

You can go ahead creating schema objects like tables.