Home > Rollback Segment > Informatica Rollback Segment Error

Informatica Rollback Segment Error

Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back snapshot too old error in oracle 11g CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS

Ora-01555 Snapshot Too Old Rollback Segment Number Informatica

Paul_Pedant DACREE MarkDeVries MacProTX VoIP_News Inside-ERP Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich Richard undo_retention DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Data ora-01555 caused by sql statement Warehouse Groups Ask a New Question Informatica The Informatica group is your premier resource for objective technical discussion and peer-to-peer support on Informatica data integration software. Home | Invite Peers | More Data Warehouse Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Rollback segment problem- with informatica even_smith asked Mar 3, 2005 | Replies (3) Hi All, We are extracting data from one database and loading into another database and made a commit in the target after 10000 records, we use an etl tool to do this. We are facing space problems in the source database, i didn't understand how we get it in source database as we are not doing any DML operation there. we have around 15 lacs of record at source.The error occqurs around when 6 lacs record has already been inserted. There are two three similar type jobs but there are runing concurenntly once in a week other wise the jobs are running sequentialy. Please ADVICE WHY WE GET THE BELOW ERROR... Error: ORA-01555: snapshot too old: rollback segment number 10 with name "RBS01_9" too small Thanks for your help. Regards, Smith Join this group Popular White Paper On This Topic Taking Business Intelligence to the Next Level 3Replies Best Answer 0 Mark this reply as the best answer?(Choose care

location is: KBSolution23Pages55377525 Sign In Log In | Sign Up | Log out Feedback Authoring Home Toggle navigation Network Home Informatica.com Communities Big Data Management Big Data Management Edition Big Data Parser Big Data Management Trial Edition Cloud Integration Cloud Application Integration Cloud Data Integration Cloud Customer 360 DiscoveryIQ Cloud Data Wizard Informatica Cloud for Amazon AWS Complex Event Processing http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/rollback-segment-problem-with-informatica-672119 Proactive Healthcare Decision Management Proactive Monitoring Real-Time Alert Manager Rule Point Data Integration B2B Data Exchange B2B Data Transformation Data Integration Hub Data Replication Data Services Data Validation Option Fast Clone Informatica Platform Metadata Manager PowerCenter PowerCenter Express PowerExchange PowerExchange Adapters Data Quality Address Doctor Address Doctor Cloud Data as a https://kb.informatica.com/solution/23/Pages/55/377525.aspx Service Data Explorer Data Quality Data Quality Services (Strike Iron) Data Security Group (Formerly ILM) Data Archive Data Centric Security [email protected] Secure Testing Master Data Management Identity Resolution MDM Big Data Relationship Management MDM Multidomain Edition MDM Registry Edition Process Automation ActiveVOS Cloud Extend Product Information Management Informatica Procurement Product Information Management Ultra Messaging Ultra Messaging Options Ultra Messaging Persistence Edition Ultra Messaging Queuing Edition Ultra Messaging Streaming Edition Vibe Data Stream Documentation Knowledge Base Resources PAM (Product Availability Matrices) Support TV Informatica Expert Assistant Velocity (Best Practices) Mapping Templates Debugging Tools User Groups Informatica Network Knowledge Base 23 KB > Solution > 23 > Pages > 55 > 377525 KB Home Page Authoring Home Top Link Bar KBCurrently selected FAQHowToSolution 6789 WhitepapersKBOktaSyncAdminKBOktaSync KB Search Authoring Home Search Demo Quick Launch Rate It: Average Rating: ERROR: "ORA-01555: snapshot too old" in Copy To Destination step while running

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business http://stackoverflow.com/questions/11972979/snapshot-too-old-error Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Snapshot too old error up vote 1 down vote favorite 1 I am getting 'snapshot too old error' frequently while i am running my rollback segment workflow when it runs for more than 5 hrs.My source is oracle and target is Teradata. Please help to solve this issue.Thanks in advance oracle teradata informatica share|improve this question asked Aug 15 '12 at 16:13 user1601052 41226 dba-oracle.com/t_ora_01555_snapshot_old.htm –Randy Aug 15 '12 at 16:15 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted The best explanation of the ORA-01555 snapshot too old error that I've read, is snapshot too old found in this AskTom thread Regards, Rob. share|improve this answer answered Aug 16 '12 at 15:36 Rob van Wijk 13.4k42139 add a comment| up vote 1 down vote The snapshot too old error is more or less directly related to the running time of your queries (often a cursor of a FOR loop). So the best solution is to optimize your queries so they run faster. As a short term solution you can try to increase the size of the UNDO log. Update: The UNDO log stores the previous version of a record before it's updated. It is used to rollback transactions and to retrieve older version of a record for consistent data snapshots for long running queries. You'll probably need to dive into Oracle DB administration if you want to solve it via increasing the UNDO log. Basically you do (as SYSDBA): ALTER SYSTEM SET UNDO_RETENTION = 21600; 21600 is 6 hours in seconds. However, Oracle will only keep 6 hours of old data if the UNDO log files are big enough, which depends on the size of the rollback segments and the amount of updates executed on the database. So in addition to changing the undo retention time, you should also make sure that few concurrent updates are executed while your job is running. In particular, updates of the data your j

 
No related pages.