 |
| ADVICE: |
| >> |
Importing data into user-defined tablespaces
TIP :Use this Oracle script to import data into your specified tablespace rather than into the system tablespace. |
| >> |
Importing and exporting a database from a remote machine
ASK THE EXPERTS :How can we do an import and export of a target database from a remote machine? |
| >> |
Importing five dump files without data duplication
ASK THE EXPERTS :I have five dump files, and I have to import those
five dump files into one single (Oracle8i) database
without data ... |
| >> |
Importing a dump file
ASK THE EXPERTS :I have an Oracle dump file (.dmp) that is currently on my local drive. How do I import this file to an Oracle database? |
| >> |
Importing a dump file from a higher version
ASK THE EXPERTS :I have an Oracle8i V08.01.06 database dump file, which was created using
conventional path. In my system, Oracle8i ... |
| >> |
Importing/exporting wrapped PL/SQL procedures
ASK THE EXPERTS :We are in the process of upgrading from Oracle 8.0.5 to Oracle 9i. Forgive me if I get things wrong, but my DBAs first ... |
| >> |
Importing data from a dump file more than one time
ASK THE EXPERTS :How can I import data (with full import option) successfully
more than one time from an exported dump file, even if we have ... |
| >> |
Transferring data in one table between schemas
ASK THE EXPERTS :Using the EXP/IMP utility of Oracle 9i, is it possible to
transfer only data of a table in one schema to a
table (of same ... |
| >> |
Importing/Exporting selected tables
ASK THE EXPERTS :In import/export, I'd like to import only selected tables, but the number of
tables is too large. I don't want to use import ... |
| >> |
Importing a file into your database
ASK THE EXPERTS :I would like to know how I can retrieve (export) data from an Oracle DB in version 7.3.4.5 to a DB in version 8.6 using ... |
| >> |
Importing data into different tablespace with a different user name
ASK THE EXPERTS :I need to export from user name 'A' from a production database
and import it to a development database with a different
... |
| >> |
Restoring data from a .dmp file using the imp command
ASK THE EXPERTS :How does one import data (not restore the full database) from a .dmp file into
an existing Oracle database with the same ... |
| >> |
Export/import migrations
ASK THE EXPERTS :What is the maximum size for export/import migrations--MB/GB/TB? |
| >> |
Monitor the import or export of an Oracle database
TIP :A script that will allow a DBA to see how many rows were imported or exported and is especially useful with big tables. |
| >> |
Importing dump file from Oracle on Linux to Oracle on Windows
ASK THE EXPERTS :How do you import a dump file from a Linux-based Oracle database into a Windows-based database? Can this also be done with ... |
| >> |
Importing data from Access to Oracle
ASK THE EXPERTS :How can I import data from MS Access database to Oracle database? This is a one time job. Is there any tool provided by TOAD, ... |
| >> |
Importing via a VB program
ASK THE EXPERTS :I am using Visual Basic to invoke the Oracle 'imp'
utility to import a .dmp file into a Oracle 9.1
database.
I have ... |
| >> |
Importing 7.3 database into 9.2
ASK THE EXPERTS :I have a 7.3.4.3 database.
I would like to export the whole database and import
it into a 9.2.0.3 database that I ... |
| >> |
Importing an export file from 8.0 to 7.3
ASK THE EXPERTS :Is possible import a export file(dmp) from Oracle 8.0 to Oracle 7.3 (under
Windows NT both)? |
| >> |
Best route to import data from
ASK THE EXPERTS :What is the best route to import data from "Lotus 123 97" workbooks into Oracle 8.0.4?
Background/pertinent info: ... |
| >> |
Using the FROMUSER/TOUSER option in imports
ASK THE EXPERTS :I used the imp function with
FROMUSER/TOUSER options.
Can I import constraints, package, package body and DB
link with ... |
| >> |
Using SQLLDR, EXPORT and IMPORT from a client machine
ASK THE EXPERTS :Is it possible to use SQLLDR from a client
machine? Is it also possible to use the EXPORT and IMPORT
utilities from a ... |
| >> |
Oracle import under Win2000
ASK THE EXPERTS :I'm using a script to do an Oracle import under Win2000. It works fine when run manually (dble click), but when I use the ... |
| >> |
Secure import/export user
TIP :Avoid the security problem of putting passwords in script files for privileged users. |
| >> |
Error IMP-00017 after switching user A's schema from prod to dev
ASK THE EXPERTS :I have an export file with user A's schema from production, and I
created a new database instance, created new
tablespace ... |
