Why are you sending it repeatedy? or is there a virus?
Regards
Naveen
-Original Message-
Sent: Wednesday, December 18, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Thanx guys for all your guidance.
Thanx Adar.
i found that an index on table 17 caused all the delay and took a
Thanx guys for all your guidance.
Thanx Adar.
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to OR
Thanx guys for all your guidance.
Dale,
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to ORACLE e
Thanx guys for all your guidance.
Thanx Kirti.
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to O
Hi
Is it possible you FTP'd the export file across to the new machine in ASCII
mode (the default on win systems)? Always ensure you use BINARY mode - the
stray LF's get substituted by CRLF's inside the export file and it really
messes up the internals and can sometimes the imp utility to skip to t
Do you have COMMIT=Y? Drop the indexes first and then import. Then create
the indexes.
-Original Message-
Sent: Monday, December 16, 2002 8:34 PM
To: Multiple recipients of list ORACLE-L
Are you importing indexes?
How many indexes there are on table #17?
Is the DB in archive log mode
Hello
After building a table the import builds constraint and indexes.
If you got a big table that can take awhile.
Check with task/performance monitor if the instance is idle or working.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]
Are you importing indexes?
How many indexes there are on table #17?
Is the DB in archive log mode?
Is the archiver getting stuck?
- Kirti
-Original Message-
Sent: Monday, December 16, 2002 8:29 PM
To: Multiple recipients of list ORACLE-L
guys,
i am exporting a DB of size 10G.
it to
guys,
i am exporting a DB of size 10G.
it totally has 33 tables.
everything completes succesfully and even the log file
says "EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING".
But while importing it,only 17 tables are imported.
after that the cursor stands still and the import does
not process
