what is the oracle database extension?? 2

[qajussi]

Hi!

My client gave me an oracle database to browse.
does xx.dmp sound like oracle database??

I also have xx.pck and I think that is thePL/SQL file.

Can you help ??

I have oracle 9i installed and I would like to open it up.
Thank you

 

[Kalin]

Sounds like the .dmp file is a dumpfile which has to be imported using import.

Import can be found in the bin directory of your Oracle home directory and /? will give you the parameters with which to import the file.

Grtz,

Kalin

 

[qajussi]

Hi!

I used the imp.exe in commandline.
I got the message like this:
import terminated successfully without warnings.
Does that mean I imported it successfully??

Another dump question??
Where does it go??

I can't find it.

I think I need an oracle 9i DBA book.
Can you help??

 

[SantaMufasa]

Quajussi,

The default behavior of "imp" (Oracle Import) is to bring objects into the same schema (Oracle User) from which the objects orginated. So, if the import did, in fact, import anything, unless you explicitly redirected the import to use a different schema name from the original, then you have a schema on your target database with the same name as the original schema.

I include the code, below, to help you find your imported tables. I store the code in a script called "ImportTimes.sql". The code displays the earliest and most recent object-create times for each schema, sorted by schema(Oracle user) from earliest to most recent times for object creates within schemas. Since you remember what time you performed the import, you can match that information with the results of the display to try and confirm the name of the "owning" schema.

set feedback off
set pagesize 35
col a heading "Earliest|Object|Create|Time" format a20
col b heading "Latest|Object|Create|Time" format a20
select	 min(to_char(created,'yyyy-mm-dd hh24:mi:ss')) a
	,max(to_char(created,'yyyy-mm-dd hh24:mi:ss')) b
	,owner
from dba_objects
group by owner
order by 1
/
set feedback on

Let us know if any of this helps.

Mufasa
(aka Dave of Sandy, Utah, USA @ 20:20 (09Jun04) UTC (aka "GMT" and "Zulu"), 13:20 (09Jun04) Mountain Time)

 

[qajussi]

Thanks millions Mufasa!!

I ran your sql and am getting "missiong or invalid option" at the line 1"!!!

Do you know why??

 

[SantaMufasa]

Qajussi,

That is a bit puzzling. Here is a copy and paste of my SQL*Plus session from which I successfully ran my code:

SQL> set feedback off
SQL> set pagesize 35
SQL> col a heading "Earliest|Object|Create|Time" format a20
SQL> col b heading "Latest|Object|Create|Time" format a20
SQL> select  min(to_char(created,'yyyy-mm-dd hh24:mi:ss')) a
  2   ,max(to_char(created,'yyyy-mm-dd hh24:mi:ss')) b
  3   ,owner
  4  from dba_objects
  5  group by owner
  6  order by 1
  7  /

Earliest             Latest
Object               Object
Create               Create
Time                 Time                 OWNER
-------------------- -------------------- ------------------
2003-09-14 23:27:09  2004-03-03 11:40:09  SYS
2003-09-14 23:27:17  2004-02-27 11:40:12  PUBLIC
2003-09-14 23:27:26  2003-09-15 00:01:58  OUTLN
2003-09-14 23:29:23  2004-02-27 11:33:11  SYSTEM
2003-09-15 01:20:10  2004-06-05 22:43:48  DHUNT

What differences can you detect between my code, above, and you invocation? Could you please copy and paste the entire contents of your invocation attempt, including resulting error message. With that, we can be more helpful.

Mufasa
(aka Dave of Sandy, Utah, USA @ 21:31 (09Jun04) UTC (aka "GMT" and "Zulu"), 14:31 (09Jun04) Mountain Time)