- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Import oracle8
Categories
Company
Local Language
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
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
Community
Resources
Forums
Blogs
- 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
04-28-2004 02:15 AM
04-28-2004 02:15 AM
Import oracle8
i do it to import in a new , and empty ,database oracle8 a export full from another database.
I do it to create previously a users or they are created automatically.
The data tablespace was created in a new database with different names.
Thanks.
Francesco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2004 02:32 AM
04-28-2004 02:32 AM
Re: Import oracle8
You can import to same user or another user. Create users with appropriate privileges (and quota) 1st.
If the tablespace name changes you will have to create the tables 1st and then import the DATA using parameter IGNORE=Y.
This is explained with more details in Metalink doc ID 1012307.6
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2004 10:25 AM
04-28-2004 10:25 AM
Re: Import oracle8
Tables/indexes will be created in the original tablespace. That is why changing a tablespace name is not normally a good idea. The only way to import a table into another tablespace is to create the table in the new tablespace, and import with the "IGNORE=Y" option on the import. This can be dangerous, as this could possibly import data twice if there is not a primary key or unique key associated with the table.
You can get a list of the table and index creation statements by issing the 'imp' command with the "INDEXFILE=table.sql", which will give all of the commands. If you just want the tables (no indexes), then you need to issue the "INDEXES=N" option as well.
Unless you really need to change the tablespace names, I would recommend going back to the original names instead of trying to change them.
Let me know if you have any questions.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2004 01:01 PM
04-28-2004 01:01 PM
Re: Import oracle8
Yes you can import from the original database from one user to the new database into another user in a straight forward way if the default tablespaces of the users were called the same name.
But you had mentioned that you created the data tablespace in the new database with different names.
Now you can still import the data, but you need to create the tables and indexes first.
So in your new database, as you had already created the tablespaces, first create the users assign the default tablespace and temporaryt tablespace and grant privileges and quotes.
Then on your old database, export the data user by user by owner =
Then on the new database you can run a fake import with the option imp fromuser=
Then you can edit this log file and save it as .sql and run against the new database to create the tables and indexes.
Then import from the same export dump file with fromuser=
You can do this for all the schemas in the old database to be imported into the new database.
I hope this helps.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2004 01:03 AM
04-29-2004 01:03 AM
Re: Import oracle8
I have created only before the users ad assigned to default tablespace, then i have imported.
Create before the tables, for rollback question was no ideally for me.
Best regards.