topic Re: how to create a schema object in Operating System - HP-UX

how to create a schema object

HPADM — Tue, 26 Nov 2002 13:03:31 GMT

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

Re: how to create a schema object

Christian Gebhardt — Tue, 26 Nov 2002 13:19:25 GMT

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

Re: how to create a schema object

John Palmer — Tue, 26 Nov 2002 13:42:13 GMT

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

Re: how to create a schema object

HPADM — Tue, 26 Nov 2002 15:09:33 GMT

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?

Re: how to create a schema object

Graham Cameron_1 — Wed, 27 Nov 2002 09:04:25 GMT

>> 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

Re: how to create a schema object

T G Manikandan — Wed, 27 Nov 2002 09:43:59 GMT

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.