Home » RDBMS Server » Backup & Recovery » - basic question, RMAN steps & view ER dig -- (won't be difficult)
icon2.gif  - basic question, RMAN steps & view ER dig -- (won't be difficult) [message #223176] Wed, 07 March 2007 20:56 Go to next message
3xxx
Messages: 1
Registered: January 2007
Location: I am HERE
Junior Member

Mad Razz


Thanks for viewing this thread, just something very basic, if you could tell me the steps and send me few relevant easy-to-follow-URL, I will very much appreciated

3 part Questions (top ones are utmost important-

1-->

RMAN -- any instruction or tutorial to do a HOT backup??


2-->

a DB got oracle as table and view, with all front-end stuff build with VB

without using TOAD (they got very simple way to see ER diagram)

how to see all the tables ( not the dba nor the system one) that the company will use

index

the FK and other constraint

view and so on

PLEASE ADVICE

3-->

on my own computer, I install oracle 9i 2 times, so I may have 2 oracle home

with SQL plus, I could see I have the standard tables
i.e. EMP, DEPT ..... (that one)

but when I check with TOAD or Oracle Ent Manager, I can only see table like COURSE, FACULTY .... (another one)

not sure it is oracle home (ORA92) or some other thing, Q>> HOW could I locate EMP, DEPT, those table... Just want to take a look

beside, when I learn FORM via book in http:\\course.com, they got some other table, with TOAD, I can search for tables such as INVENTORY, ORDER .... etc, but I don't know how to locate those table with any other method

for database, one I called orcl , there is another one that appear (I forgot when I create it -- orcl_127.0.0.1, any clues on that)


I realise that they are VERY BASIC for you, please help

Cool Razz
Re: - basic question, RMAN steps & view ER dig -- (won't be difficult) [message #223181 is a reply to message #223176] Wed, 07 March 2007 21:22 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1).
Just serach the forum. There are many examples.
Search google/Oralce documentation.
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm
Before getting into these first you need to understand archivelogging, catalog/nocatalog mode backup etc.
Start with documentation!.
2).
Login as the schema owner do a
select * from cat;

This will display the tables/views etc.
there specific views to query user_table/user_indexes/user_constraints etc.
For starters, it is better to use gui tools like
http://www.oracle.com/technology/products/database/sql_developer/index.html
3).
Probably you have two different databases and toad is look into the other one.
If these installation are for learning, APEX is the Best.
It has the real backend along with a GUI interface for rapid application development.
http://www.oracle.com/technology/products/database/application_express/index.html
Previous Topic: 8i to 10g2 Migration with ASM disk
Next Topic: Restore from previous version
Goto Forum:
  


Current Time: Tue Dec 06 04:41:41 CST 2016

Total time taken to generate the page: 0.15992 seconds