December 2002
Intermediate to advanced
928 pages
85h 29m
English
Content preview from Oracle in a NutshellBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Export/Import Fundamentals
The Export and Import utilities can be used in two different modes:
- Interactive
In this mode, the utility prompts the user for the information needed for the task.
- Command line
In this mode, the information needed for the task is included either on the command line or in a specified parameter file.
The interactive mode for the Export and Import utilities is essentially a legacy interface, left over from earlier releases of the software. Using the command-line interface gives you more flexibility.
If you use the Export and Import utilities for moving data between different versions of Oracle, you will need to pay attention to which version of the utilities you use. The Import utility used must be the same as the version of the database that is receiving the data, and the Export version must be the same as the lower of the two versions being used.
To run any version of Export or Import, you must run the catexp.sql or catalog.sql script to prepare the database for these operations.
Tip
Throughout this chapter, we’ll show the Export command and Import command names as exp and imp, respectively. Those will be the correct command names on most systems. Note, however, that in older Oracle releases on Windows systems, release numbers were embedded in the executable names, so on such systems you may encounter names like imp80, exp73, and so on. If you have any doubt, refer to your platform-specific documentation for the specific name used to invoke these utilities on your ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.