- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Full database imort issue !!
Operating System - HP-UX
1754194
Members
4148
Online
108811
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2004 02:37 PM
тАО05-14-2004 02:37 PM
Full database imort issue !!
Hi there,
Just wondering if I run a full database import against a database, will the user account password be overwritten in the target database ?
I am currently using Oracle 8.1.7.
Test shows me that the existing user account and password in the target database remains the same. I think this issue may affect if the import job is for a disaster recovery situation.
Any comments ??
Cheers,
Chris,
Just wondering if I run a full database import against a database, will the user account password be overwritten in the target database ?
I am currently using Oracle 8.1.7.
Test shows me that the existing user account and password in the target database remains the same. I think this issue may affect if the import job is for a disaster recovery situation.
Any comments ??
Cheers,
Chris,
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2004 05:37 PM
тАО05-14-2004 05:37 PM
Re: Full database imort issue !!
Chris,
I'm not sure what you are looking for. The IMP_FULL_DATABASE role has the BECOME USER privilege, which lets it create objects as another user. There isn't any real knowlege of the password in the import dump file, just the encoded value of the password that can be loaded into Oracle directly.
Provided that the user exists on the database (or can be created with the import), then the objects should be created, provided that tablespaces exist with sufficient space.
Thanks,
Brian
I'm not sure what you are looking for. The IMP_FULL_DATABASE role has the BECOME USER privilege, which lets it create objects as another user. There isn't any real knowlege of the password in the import dump file, just the encoded value of the password that can be loaded into Oracle directly.
Provided that the user exists on the database (or can be created with the import), then the objects should be created, provided that tablespaces exist with sufficient space.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2004 06:18 PM
тАО05-14-2004 06:18 PM
Re: Full database imort issue !!
Hi Chris,
Performing a FULL Export will export the entire database. Performing a FULL import will import everything in the export dump file.
A full import will create any undefined tablespaces using the same datafile names as the exported database.
If you have a target database, and the users, datafiles, tablespaces are pre-created, import will not change the user passwords in the target database.
Indira A
Performing a FULL Export will export the entire database. Performing a FULL import will import everything in the export dump file.
A full import will create any undefined tablespaces using the same datafile names as the exported database.
If you have a target database, and the users, datafiles, tablespaces are pre-created, import will not change the user passwords in the target database.
Indira A
Never give up, Keep Trying
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2004 04:48 AM
тАО05-15-2004 04:48 AM
Re: Full database imort issue !!
Indira,in imp full=y if your you have one user created in base target with the same username of the user of the base origin the password of the base target be overwritten, because you are importing the data dictyonary too.
IF the user didn't exist in the base origin there won't be changes.
Chirs,
If the users of the base origin for the disaster recovery didn't exist in the destination, I don't see problem, if for the opposite they already existed you have to fight with the integrity of your data.
greetings
E.
IF the user didn't exist in the base origin there won't be changes.
Chirs,
If the users of the base origin for the disaster recovery didn't exist in the destination, I don't see problem, if for the opposite they already existed you have to fight with the integrity of your data.
greetings
E.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP