Server Utilities :: Oracle 11.2.0.1 Imp.exe Appcrash
Oct 31, 2013
I have a dump file (exp done from Oracle 10.2) and i want to import this dump in Oracle 11.2.0.1 (Windows 7 32 bit). The import work nice until, I got a crash message from Windows:
load data infile 'trlc.csv' replace into table trlc fields TERMINATED BY '|' TRAILING NULLCOLS (est_no,right_no,maj_auth,weight,idm_ht,c_date,P_tkt)
The rows get inserted successfully. But the result sets are different, for example: When I do a select in SQL Server,'select len(weight) from trlc;' , I get the length as 0. But when I do a select in oracle database, I get the length as 1. Also, the result set varies for the query below:
select * from trlc where weight=' ';
(SQL Server returns 1 row but Oracle returns no rows)
Do I need to mention any conversion code for the weight field to accept ' ' value?
I have the problem with import in Oracle 8.1.7.The size of import file is 29600 kb and tablespace size is 16gb and when I try to make import oracle back this message:
IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace DATA
The data tablespace is full. I think that the import file contains information about the original tablespace from which has made export. But I don't now how to resolve the problem
I am trying to export Schema using expdp command. but its going hang after few minutes. it seems that it stucks any where. Even I am trying with normal scott schema it is also hanging.
I would like to run a daily job that will export the table data from SQL server table and Import back into Oracle table. I might need to run the query to update the flag back into sql server table once job is done. How can i do this using either sql server or oracle?
We have oracle 9.2 and sql server 2005.
Normally i do from flat file or csv file which is generated by developer or user from source destination (not me) and i dump into oracle using sql*loader but this time I have to directly extract/export the data from MS Sql server and load into Oracle table, mostly it will reload so i might doing any massaging data during the load.
Is it sql sql*loader has any function that i can use the datasource to connect the MS Sql server and fetch the data and insert back data into oracle? I have access to Sql server but i don't how to use sql server to do this or using oracle as a daily job even because have to schedule the job for this as it will be a daily job.
Actually I have done some search but with no result. I have to check the oracle DMP file which is being sent through the EXP utility from oracle and have to search for a pattern in the file. If the pattern in found then send a mail.
I have tried using the GREP on the DMP and SED but as the lines are longer than expected these are not providing desired results.
We have three instances on the RAC, When I create a directory is there a default instance that it gets created on? When I execute an datapump export on instance 1, it works but on 2 and 3 it fails with error relating to directory.
Error - ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 475 ORA-29283: invalid file operation
I have Windows server working Oracle 8.0.5.I have to migrate to another server that is Oracle 11gR2 on Windows 2008.Some say I can't do Export and Import directly.And some say DBlink is not working from 11Gr2 to 8.
What can be fewest step to migrate?Somebody try to use 'Oracle directory' and VB and Powerbuilder program to send data and DDL from 8 to 11Gr2.
I need some support on older version of oracle. Its 7.1 and it runs on alpha 2100 with open vms 6.1 OS. I was looking at option of alpha virtualization in sometime soon. I have set of backup hdd and one set of alpha 2100 spare machine.
But lately, just the oracle processes keeps shutting down soon unexpectly. It was complaining about couple of bad block , SO i found that objects(tables) , dropped them and created them.
After few days, it does the same thing again...The log says 'File 2 at .....needs media recovery'.....I wanted to recovery that datafile but When I try to connect using 'sqlplus' , it says
'ora: 01034: oracle not available' '0ra-0765:$msget :$mgblsc failure' --- no such global section
How do one recovery database or datafile without connecting to SQLPLUS?
LOAD DATA INFILE * INTO TABLE image_table REPLACE FIELDS TERMINATED BY ',' (
[code].....
step 3)
Then i have run this command
F:oracleproduct10.2.0db_1in>sqlldr control=F:practicecontrol.ctl Username:system Password so i got this error SQL*Loader: Release 10.2.0.5.0 - Production on Wed Jun 8 13:47:27 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. SQL*Loader-404: Column FILE_ID present more than once in IMAGE_TABLE's INTO TABL E block.
I have received a dump, which i need to put on a newly created schema, there is a particular table with more then 4 million rows, and other tables have hardly few thousand rows.
I want to import it in a way where only 1000 rows get imported for this table and other tables do not get affected. Is there a way to do it?
I have been trying to inset an excel spreadsheet into oracle. I can import everything fine but whenever I need to import a sheet that includes dates it does not work.
Is there a special formatting I need to do with excel(I have tried just about every date format in excel and tried matching the date style to the one in oracle and tried doing the opposite)? I have tried every step that I can possibly think of.
whenever I format the Date in the Oracle loader it gives me the Success message for the dates but still fails to load? ive also tried many format with the oracle loader.
In a flat file 50000 records are there.In that some of the records having special charcters.From that special character record the remaing records are not loading to oracle tables. to load the remaining records,after the record which is having special characters.The data is loading using sql*loader
but actuly i want to file_name is my actul employee name like Ramesh Patel so what are the changes i can do into my this control file so i can get this file name as my employee name and using this tool i can upload 1500 images into database easily
I want to import 1 .dmp file into oracle database. I dont know what exactly what that .dmp file contains e.g i dont know the Users inside the dump.While importing it gives me the error.
1. Do i need to create those users first and then import if yes then how would i know how many users are inside that dump.
2. Currently the objects are created in SYSTEM user by default. I want to import those objects in the MACL user which i created. How can i do it?
IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCCOMAN' does not exist IMP-00017: following statement failed with ORACLE error 1917:
every day we have full backup of oracle database (9.2.0.1.0) on windows 2003 server. since couple of days i am getting following below error. i checked the solutions on google which talk about user quotas , i checked the user quotas by which i am taking full backup it is unlimited , even i tried another user which also have umlimited quota on its default tablespace still i getting below
E:ackup>exp system/manager file=full26022012.dmp log=full26022012.log full=y statistics=none EXP-00008: ORACLE error 933 encountered ORA-00933: SQL command not properly ended ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311 ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142 ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
even i go for full export by any other user which has full export privilege & unlimited quotas. i getting the same error.
E:ackup>exp username/password file=full26022012.dmp log=full26022012.log full=y statistics=none EXP-00008: ORACLE error 933 encountered ORA-00933: SQL command not properly ended ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311 ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142 ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
I have migrated from postgres to oracle entire databases however some tables have spaces how can they be removed and how can i found out all the tables in a schema with spaces?
In oracle 11g R2 , I face a problem when I export/import xml records in the tables . Everytime it takes huge time (like 2 or 3 days) to import or export the data . But the dump size is very small (4gb) and this dump comes from a vendor so that I dont understand that is it a data structure problem or it the normal behaviour to import xml records.
I am not used to with xml record with oracle database before. Here I am using datapump feature . I also mention that when I delete the schema (where I imported the xml data) , it also takes 2/3 days to delete.The import script will hang in the following stage :
Import: Release 11.2.0.1.0 - Production on Sun Jan 29 11:10:38 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_SCHEMA_02": system/******** DIRECTORY=isb_dir DUMPFILE=jblbld_20110301_01.dmp,jblbld_20110301_02.dmp,jblbld_20110301_03.dmp logfile=JBLBLD_28Jan2012.log schemas=TBLD Processing object type SCHEMA_EXPORT/USER [code]...
The machine has 16 cpu , 32 gb RAM and during export/import most of the time maximum memory will free.
