Is there a tool available to browse an Oracle Dump file. I want to view the objects and the data in the object without having to import the data into an Oracle Schema. I want to do this to verify some dump files that I have. Thanks, Troy. Daniel Stanley. Join our community to see this answer! Unlock 2 Answers and 5 Comments. Oracle Database Utilities for information about using the Data Pump utility. The new location must be accessible to the target database. Transport the data files of the user-defined tablespaces in the database to a place that is accessible to the target database.
In this example, transfer the following data files from the source database to the target database:. If you are transporting the database to a platform different from the source platform, then determine if cross-platform database transport is supported for both the source and target platforms, and determine the endianness of each platform.
If both platforms have the same endianness, then no conversion is necessary. Otherwise you must do a conversion of each tablespace in the database either at the source or target database. If you are transporting the database to a different platform, you can execute the following query on each platform. If the query returns a row, then the platform supports cross-platform tablespace transport.
In this example, you can see that the endian formats are different. Therefore, in this case, a conversion is necessary for transporting the database.
Transport the data files to the location of the existing data files of the target database. If no endianness conversion of the tablespaces is needed, then you can transfer the files using any file transfer method.
The Data Pump Import program is a tool that allows you to load an export dump file set into a target Oracle database system.
The dump file set consists of one or more disk files that store table data, database object metadata, and control information. I have an oracle full dump. I know I have to imp the dump with the fromuser touser clause.
However I don't know the names of the schemas included in the dump. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. List the contents of Oracle export dump file Ask Question.
0コメント