Hi guys and ladies,
I am still having a problem understanding the parfile method in export and import
Assuming I export
exp parfile = test.txt
and the contents of Test.txt are as follows
constraints=n, indexes=, ignore=y, direct=y,
Can any one please complete the LOG PORTION OF EXPORT (i.e. where I have log=/u02/ .................)
and explain that to me?
Then show me an example of how you will import the above exported file to another database assuming it has already being FTPed to that database
[Edited by dorothy on 11-29-2000 at 07:15 AM]
log= ... mean the path and filename you want for the log
then ftp your file to the other machine IN BINARY, so can go for imp:
Yes, the log will just list what is being outputt to screen in to a file - call it anything you like:
Exporting User Scott....
Table EMP ......1 row exported
Table DEPT ......10 rows exported
It's good to have because errors disppear off the screen quickly, and it also logs how many rows each table had on export.
FTP in binary mode:
Create a parfile (I assume the table doesn't exist?.. If it does, be sure to include ignore=y)
you can use commit=n either i) if you're importing into a table which already has data ii) You have Rollback segments big enough to cope with the load.
then just run:
One other thing - If you're importing in direct more (because that is the way you're export was done), you must be sure that you have all you're character sets set correctly.
Are the two database's the same NLS_ ?
Make sure the environment variable NLS_LANG is the same as your database setup too, or you'll get an error when trying to import.
In your export parfile, you have 'ignore=y'
Ignore is an import parameter not export.
To get a list of export parameters do
for import parameters
Click Here to Expand Forum to Full Width