| List all users in a dmp file. [message #235559] |
Mon, 07 May 2007 03:28  |
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 #235564 is a reply to message #235562] |
Mon, 07 May 2007 03:50  |
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 #235570 is a reply to message #235567] |
Mon, 07 May 2007 04:30 |
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
