| Import skips table [message #242049] |
Thu, 31 May 2007 08:50  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
I've taken export of one table from schema USER1,using the following parameters,
tables=USER_FAX
buffer=268435456
statistics=none
indexes=y
I'm trying to import the table into another schema USER2 with the following import
parameters,
fromuser=USER1
touser=USER2
indexes=y
indexfile=IndxScript.txt
buffer=268435456
commit=y
rows=y
But it's not importing table,but it creates index file which is containing DDL for,
1. USER_FAX table
2. Index
3. Enabling constraints
Please see below the import log file,
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by USER1, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. . skipping table "USER_FAX"
Import terminated successfully without warnings.
My questions are,
1. Why it's skipping table,what i've to do to import this table into USER2 schema?
2. In indexfile created, i don't need DDL statement for Table & remove REM word attached
to each line.What i've to do to achieve this?
Thanks...
|
|
|
|
|
|
| Re: Import skips table [message #242404 is a reply to message #242049] |
Fri, 01 June 2007 16:27  |
Thagor
Messages: 9
Registered: April 2007
|
Junior Member |
|
|
Hi ganjini,
The problem in your parameters is the parameter indexfile, which instructs the import utility to just write all the information about the to-be-imported table and its indexes to the filename given. This is usually just used to get the create statements (mostly of objects which fail to create), not the indexes or tables themself.
Even if the table already exists in the user2 schema your indexfile-file should have contained the create statement of the table too. Are you sure that your export is okay?
If so, drop the indexfile parameter ... and may be add ignore=y instead to be on the sure side ... and try again.
Good luck
Thagor
PS: Just for fun, why are your using such an enormous buffer without feedback?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
