HPE GreenLake Administration
- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle imp usage
Operating System - HP-UX
1827975
Members
2630
Online
109973
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
Forums
Discussions
Discussions
Discussions
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
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
02-27-2008 06:50 AM
02-27-2008 06:50 AM
oracle imp usage
Hi All,
I have an user schema in one database and I would like to duplicate it in my personal ORCL.
I already export the user schema in some dmp file. But my questions are?
1. do I need to create this user in my ORCL instance? Then I have to create tablespace for the users as this user is on a tablespace which does not exist in ORCL.
2. do I need use "system" to do the export and then import.
Please let me the steps.
Thanks,
Jane
I have an user schema in one database and I would like to duplicate it in my personal ORCL.
I already export the user schema in some dmp file. But my questions are?
1. do I need to create this user in my ORCL instance? Then I have to create tablespace for the users as this user is on a tablespace which does not exist in ORCL.
2. do I need use "system" to do the export and then import.
Please let me the steps.
Thanks,
Jane
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2008 06:56 AM
02-27-2008 06:56 AM
Re: oracle imp usage
Hi
you can import it in a new schema with this parameters of the imp command:
FROMUSER=USER_OF_ORG_DB
TOUSER=USER_OF_ORCL_DB
the user USER_OF_ORCL_DB must have enough space.
Regards
you can import it in a new schema with this parameters of the imp command:
FROMUSER=USER_OF_ORG_DB
TOUSER=USER_OF_ORCL_DB
the user USER_OF_ORCL_DB must have enough space.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2008 07:15 AM
02-27-2008 07:15 AM
Re: oracle imp usage
Yes do the import as system.
Also you will need to grant permissions to the tablespaces for that schema before the import whish means yes you need to create the user/schema befor the import.
Also you will need to grant permissions to the tablespaces for that schema before the import whish means yes you need to create the user/schema befor the import.
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.
Company
Support
Events and news
Customer resources
© Copyright 2025 Hewlett Packard Enterprise Development LP