Home » RDBMS Server » Backup & Recovery » List all users in a dmp file.
List all users in a dmp file. [message #235559] Mon, 07 May 2007 03:28 Go to next message
760613
Messages: 16
Registered: March 2005
Junior Member
Hi I wonder if this is achievable...

I received a full db export file (dmp file), which I try to import.

I dont want to import the full-database but just some user selection (schemes) that I really want.

i.e. using imp with:
imp ... full=n fromuser=user1 touser=user1

Now I wonder, how do I get the user names from the dmp file ???

Is there any way to fetch the needed information? using tools? command lines? unix tools?...


PLEASE advice.
Re: List all users in a dmp file. [message #235561 is a reply to message #235559] Mon, 07 May 2007 03:34 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
VERSION=????????????
Because, if you are on 10g, you can use the power of data pump to do exactly what you want!
Re: List all users in a dmp file. [message #235562 is a reply to message #235561] Mon, 07 May 2007 03:39 Go to previous messageGo to next message
760613
Messages: 16
Registered: March 2005
Junior Member
Hi Saibal,

the dmp file has been created on Oracle9
but I want to import it into an Oracle10g (sqlplus release: 10.2.0.2.0)

Thank you for helping.
Re: List all users in a dmp file. [message #235564 is a reply to message #235562] Mon, 07 May 2007 03:50 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
No, I am afraid data pump import will not work with databases that are older than oracle database 10g release 1 (10.1). So, I guess, you will have to use the older imp/exp utility, which is still supported in 10g. But then, I am not sure how you will do the filtering of data with imp/exp. with data pump, that is one of its 'sweet spots'
Re: List all users in a dmp file. [message #235565 is a reply to message #235564] Mon, 07 May 2007 03:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
No, I am afraid data pump import will not work with databases that are older than oracle database 10g release 1 (10.1).


We can import older than 10g dump file through OEM.

Regards
Taj
Re: List all users in a dmp file. [message #235567 is a reply to message #235565] Mon, 07 May 2007 04:02 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
Can you please point me to the piece of documentation that says what you are saying. Till such time I will continue to stand by:
Data Pump import will NOT work with databases that are older than Oracle database release1 (10.1).

[Updated on: Mon, 07 May 2007 04:24]

Report message to a moderator

Re: List all users in a dmp file. [message #235570 is a reply to message #235567] Mon, 07 May 2007 04:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

We can import older than 10g dump file through OEM.


Oracle enterprise manager
----->Maintenance
---------------------->Import from Files
Database Version of Files to Import : Prior to 10g

Here two option : 10g or later
Prior to 10g


Import Type

Manually specify what you want to import
You need to know the contents of the database being imported to correctly use this option.

Click on "continue" and select which schema or which tables you want to import and click on next.

Through this we can import older than 10g dump file through OEM.

regards
Taj

before that you know about which file you want to import and which schema if dump file is FULL DATABASE.

ORCL@TAJ>host imp file=emp.dmp log=dummy.log show=y


Regards
Taj

[Updated on: Mon, 07 May 2007 04:31]

Report message to a moderator

Re: List all users in a dmp file. [message #235571 is a reply to message #235570] Mon, 07 May 2007 04:47 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
Precision in language is very important. If you read my posts, you will see that I keep on maintaining that you cannot use data pump to import a database older than version 10.1
Whether you can do that through OEM,TOAD,HTMLDB,SQL DEVELOPER is moot point.
Secondly, the OP was interested in 'filtering the import data'. That is a piece of cake with data pump's filtering and remapping parameters. You will have to tell me whether that can be accomplished by usimg OEM? If yes, then I am sure the OP will be interested in hearing that. If no, then I guess, you are barking up the wrong tree.
Regards
Re: List all users in a dmp file. [message #235601 is a reply to message #235571] Mon, 07 May 2007 06:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Now I wonder, how do I get the user names from the dmp file ???
As alredy suggested by Taj, use show=y using imp .
Get the users/tablespace precreaed. Do an import using imp (not impdp).

[Updated on: Mon, 07 May 2007 17:49]

Report message to a moderator

Previous Topic: how to take backup from LAN client with EXP (9i)?
Next Topic: keeping track of Archive Logs in ASM
Goto Forum:
  


Current Time: Fri Dec 09 11:33:34 CST 2016

Total time taken to generate the page: 0.10247 seconds