| User Mode Import [message #136629] |
Fri, 09 September 2005 02:57  |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi,
I have Oracle 8i with Win 2000 Prof... I need to import a .dmp file in Oracle... The .dmp file contains many users.. But I need to import only from a particular user (User1).. So I am creating a parameter file mentioned below to import the data...
Parameter file
file=g:\export.dmp
fromuser=user1
touser=oper1
log=d:\import.log
The data has been imported successfully... Now my question is that whether the data imported by this contains all constraints or not... I need to import the constraints also... How can I find out whether the constraint has been created or not??
Thanks,
Avra
|
|
|
|
|
|
|
|
| Re: User Mode Import [message #136640 is a reply to message #136636] |
Fri, 09 September 2005 04:25  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
As i know
By default the value of constraints parameter is yes, so if u have imported a user without specifying constraints parameter then it should be imported.
I mean to say that if u have not used
constraints=n
in your command then it should be imported.
If there is anything new then pls let me know also.
regards,
tarun
|
|
|
|
| Re: User Mode Import [message #136646 is a reply to message #136640] |
Fri, 09 September 2005 05:43 |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi,
I think u r right... I ve not mentioned anything abt the constraints in the parameter file.. So by default it should import all the constraints.. Is there any way by which whatever constraints are in a .dmp can be viewed without importing the data actually??.. I mean to say if i user indexfile as a parameter of imp utility, will it show all the constraints creation DDL from the .dmp file??
Thanks,
Avra
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
