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