-
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
full=n,
file=/u02/extension/group/ext.dmp
tables= tablename
grants=n
constraints=n, indexes=, ignore=y, direct=y,
buffer=200000000
log=/u02/....................................
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
thanks,
dorothy
[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:
imp parfile=file
-
Yes, the log will just list what is being outputt to screen in to a file - call it anything you like:
e.g.
Exporting User Scott....
Table EMP ......1 row exported
Table DEPT ......10 rows exported
etc.
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)
userid=user/password
file=/..../ext.dmp
commit=y
log=/.../ext_imp.log
buffer=
tables=tablename
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:
imp parfile=parfilename
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.
Terry
-
Dorothy,
In your export parfile, you have 'ignore=y'
Ignore is an import parameter not export.
To get a list of export parameters do
exp help=y
for import parameters
imp help=y
