import
Hi
I will describe you what I did exactly.
I made four batches, the first one is to drop all the users I have accept sys user ,
the second batch is to create all the users whitch I dropped,
and the third batch file is to grant dba roll to all the users I created,
and the fourth one is to grant unlimited tablespace to all the users I created.
imp sys/sys file=/exp_file.dmp ignore=y grants=yes log=dbimp.log full=y
this was the command I used to import the whole database.
when this command proceeded the first thing appeared is this error:-
IMP-00017: following statement failed with ORACLE error 2237:
"CREATE TABLESPACE . . . . . . . . . . . . . .
IMP-00003: ORACLE error 2237 encountered
ORA-02237: invalid file size
IMP-00017: following statement failed with ORACLE error 2237:
"CREATE TABLESPACE . . . . . . . . . . . . . . . . .
IMP-00003: ORACLE error 2237 encountered
ORA-02237: invalid file size
importing....... figel into figel
importing table ...figelt_mst 253 rows
despite these errors the import is going and many users imported successfully,but there are some errors appeared once again.
imp-00003:oracle error encountered.
ora-01562:failed to extend rollbacksegments number 5.
ora-01650: unable to extend rollback segments RDS005 by 256 in tablespace RBS.
ora-01730:invalid number of column names specified.
ora-01789:query block has incorrect number of result columns.
after these errors the import is proceeded with other users well, but there are sevens views could not be created during the import.
imp-00020:long column too large for column buffer size (30506)
imp-00041:warning object creeated with compilation warnings
ora-04063: view fischv_acc has errors
and in the end the import completed successfully with warnings.
my company asked me to do import and you see the difficulties I am in.
why creating tablespace during the import is launching despite that I did not remove any of the tablespaces, I only deleted the users.
the tablespaces which had a issue have many objects.
I found the datafiles which linked to failed tablespaces what that means please.
imp sys/sys file=/exp_file.dmp ignore=y grants=yes log=dbimp.log full=y indexfile=objects_stra.sql
is this the command you would like me to execute?
if yes, I will run it any time soon.
This would not import anything to the database but would create a sql file to all the views and tablespaces which failed only.
please could you help me to fix these errors.
bye