OraFAQ Forum: Server Administration » how to get tables in oracle 10g database (merged)

Home » RDBMS Server » Server Administration » how to get tables in oracle 10g database (merged) (RHEL 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to get tables in oracle 10g database (merged) [message #486071]

Mon, 13 December 2010 07:42

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

hi everybody,

I have installed oracle 10g software and created Database on RHEL 4. when i run the run.sql its successively done but im not getting tables. whats the prob. pls give me support.

Tejo krishna.Y

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486073 is a reply to message #486071]

Mon, 13 December 2010 07:47

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

What does run.sql do?

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486076 is a reply to message #486073]

Mon, 13 December 2010 08:16

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

with run.sql file, i executed catproc.sql, catalog.sql and pupbld.sql with system/manager. the process is successively done but im not getting tables.

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486077 is a reply to message #486076]

Mon, 13 December 2010 08:19

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

What tables do you expect to get?
How are you checking for their existence?

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486078 is a reply to message #486077]

Mon, 13 December 2010 08:21

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

i tried to get the emp table with select *from emp;
its not working.

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486079 is a reply to message #486078]

Mon, 13 December 2010 08:23

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

its giving error as table not exist

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486080 is a reply to message #486078]

Mon, 13 December 2010 08:27

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

None of those scripts create an emp table. They create the data dictionary - the basic sctructures oracle needs to work.
You want to install the scott schema.

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486081 is a reply to message #486080]

Mon, 13 December 2010 08:33

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

tell me installation of that step wise pls

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486082 is a reply to message #486081]

Mon, 13 December 2010 08:34

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

Click on link above. Look at section titled install. Read.

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486083 is a reply to message #486082]

Mon, 13 December 2010 08:55

najjuizzhere
Messages: 7
Registered: December 2010
Location: BAHRAIN

Junior Member

Dear Freind ,

While You create the database with create database command a file name called sql.bsq will run which will create
base tables for oracle .

After that you are so called run.sql is having catalog.sql , catproc.sql and pupbld.sql

1) Catalog.sql -> It creates you $tables which is hard to read for end user.
2) Catproc.sql -> It creates the packages , procedures and user readable views.
3) pupbld.sql -> It create product_user_profile table and view for restricting user {It should be run from system/manager}

Scott tables like emp , dept , salgrade in oracle 10g will be locked , so you need to unlock the scott table and use it

conn / as sysdba
alter user scott account unlock;
conn scott/tiger

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486098 is a reply to message #486083]

Mon, 13 December 2010 10:29

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SCOTT schema and tables are not created unless you create them.
In addition, tables are not locked nor the schema unless you lock it by yourself.

Regards
Michel

[Updated on: Mon, 13 December 2010 10:30]

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486142 is a reply to message #486098]

Mon, 13 December 2010 22:44

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

when im trying to run @?$ORACLE_HOME/admin/utlsampl.sql with scott user. its going to os promt directly. Still im not getting the emp table in oracle 10g. pls give me support.

Tejo krishna.Y

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486143 is a reply to message #486142]

Mon, 13 December 2010 22:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>when im trying to run @?$ORACLE_HOME/admin/utlsampl.sql with scott user.
Need to be run from highly privileged account; not from SCOTT

It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486144 is a reply to message #486143]

Mon, 13 December 2010 22:56

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

this link is going to guidelines for this faq. where i get the solution.

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486145 is a reply to message #486144]

Mon, 13 December 2010 23:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486146 is a reply to message #486145]

Mon, 13 December 2010 23:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

bcm@bcm-laptop:~$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 13 21:08:16 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @?/rdbms/admin/utlsampl.sql   
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bcm@bcm-laptop:~$ sqlplus scott/tiger

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 13 21:11:52 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486151 is a reply to message #486146]

Tue, 14 December 2010 00:18

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

[oracle@localhost ~]$ !sq
sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 14 11:38:15 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @?/rdbms/admin/utlsampl.sql

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@localhost ~]$

this is the prob, when im running that its going to os prompt directly. what i need to do

Report message to a moderator

Re: how to get tables in oracle 10g database (merged) [message #486152 is a reply to message #486151]

Tue, 14 December 2010 00:37

tejokrishna
Messages: 15
Registered: December 2010
Location: Hyderabad

Junior Member

thankx for your supports

i got the tables now

when i connected to sqlplus scott/tiger..

[Updated on: Tue, 14 December 2010 01:26] by Moderator

Report message to a moderator

Previous Topic:	I try To Alter SGA but it give ne error
Next Topic:	Reporting schema suggestions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:45:24 CST 2024