how to create a schema object

[HPADM]

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

[Christian Gebhardt]

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]

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]

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]

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

[T G Manikandan]

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.