Oracle Error 1552 Encountered
Contents |
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise ora-01552 solution and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications
Ora-01552: Cannot Use System Rollback Segment For Non-system Tablespace
Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q ORA-01552 with import command I am supporting a system that uses export for backup. I want to test the import command to create a new database on a different machine. I run ORADIM to create a new instance and then create database to create the new database, and @catalog.sql and @catproc.sql. I then run the import command. The system returns "IMP-00058: ORACLE error 1552 encountered" and "ORA-01552: cannot use system rollback segment for non-system tablespace." Sections Share this item with your network: Related Expert Q&A Using Undo Tablespaces vs. rollback segments in ... – SearchOracle Moving from rollback
"APPS.FND_PROG_ONSITE_INSERT", line 4ORA-04088: error during execution of trigger 'APPS.FND_PROG_ONSITE_INSERT' Solution: We have dropped the index FND_CONC_PROG_ONSITE_INFO_U1 and import the table FND_CONCURRENT_PROGRAMS and finally create the index. SQL> Drop index FND_CONC_PROG_ONSITE_INFO_U1; Index dropped. dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_CONCURRENT_PROGRAMS commit=y ignore=Y log=/temppi/refresh/mad/MAD4tables2011-01-21.dmp.dmas.import.log4_ssi_1 Import: Release 10.2.0.3.0 - Production on Fri Jan 21 17:51:43 2011 Copyright (c) 1982, 2005, Oracle. All rights http://searchoracle.techtarget.com/answer/ORA-01552-with-import-command reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options Export file created by EXPORT:V10.02.01 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses http://suryakanta-sahu.blogspot.com/2011/10/export-import-issues.html UTF8 character set (possible charset conversion) export client uses UTF8 character set (possible charset conversion) . importing APPLSYS's objects into APPLSYS . . importing table "FND_CONCURRENT_PROGRAMS" 9841 rows imported Import terminated successfully without warnings. SQL> select count(*) from APPLSYS.FND_CONCURRENT_PROGRAMS; COUNT(*) ---------- 9841 SQL> CREATE INDEX "APPLSYS"."FND_CONC_PROG_ONSITE_INFO_U1" ON "APPLSYS"."FND_CONC_PROG_ONSITE_INFO" ("PROGRAM_APPLICATION_ID", "CONCURRENT_PROGRAM_ID") PCTFREE 0 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT) TABLESPACE "APPS_TS_TX_IDX" ; Index created. Issues: IMP-00058: ORACLE error 1552 encountered ORA-01552: cannot use system rollback segment for non-system tablespace 'APPS_TS_SEED' Import terminated successfully with warnings. We tried to execute the import command with below command and got the error. dmas1> imp applsys/apps file=/temppi/refresh/mad/MAD4tables2011-01-21.dmp fromuser=APPLSYS touser=APPLSYS TABLES=FND_USER commit=y ignore=Y CONSTRAINTS=N indexes=N log=/tempp
system rollback segment for non-system tablespace ‘USERS’ ORA-01552: cannot use system rollback segment ... that use catalog database fails with http://www.orasites.net/q/30/ORA-01552%20cannot%20use%20system%20rollback%20segment%20for%20non-system%20tablespace following deadlock errors. RMAN-00571 …… ORA-01552: cannot use system ... segment http://www.orafaq.com/forum/t/48463/ for non-system tablespace ‘USERS’… ORA-00021: session attached to some other process; cannot switch ... oracle --- Oracle rollback segments - Database - Database Skill http://www.databaseskill.com/4535137/ Similar Pages ... ORA-01552 error ORA-01552 cannot use system rollback segment for non-system tablespace. This error is not oracle error available ... subsystem rollback segments and non-system rollback segment, where non-system rollback segment is divided ... the system non-system rollback segment. The reason is as follows: ? Apart system rollback segment, not ... ERROR - ORA-00603 http://kb.dbatoolz.com/tp/270.error_-_ora-00603.html Similar Pages ... 24_dssst.trc: ORA-01552: cannot use system rollback segment for non-system tablespace 'RBS' 1092 2003-DEC-05 oracle error 1552 ... during: drop rollback segment RBS1 ... Mon Jun 18 16:05:42 2001 drop rollback segment RBS2 Mon Jun 18 16:05:42 ... was the following (all non SYSTEM rbs was OFFLINE): Mon Jun 18 16:05:28 2001 ORA-1534 signalled during: ... Oracle Rollback (ROLLBACK) and revocation (UNDO) - Sql - Database Skill http://www.databaseskill.com/5007073/ Similar Pages ... ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS' - View ... received the error message - A non-system tablespace can not use rollback segment SQL> INSERT INTO scott.emp ... View the segment type, found that the system tablespace ROLLBACK segment, so an insert statement receive ... Oracle Rollback (ROLLBACK) and revocation (UNDO) - Database - Database Skill http://www.databaseskill.com/1509351/ Similar Pages ... ERROR at line 1: ORA - 01552: cannot use system rollback segment for non - system tablespace 'USERS' - View ... received the error message - A non-system tablespace can not use rollback segment SQL>
07 July 2005 13:00 otb82 Messages: 2Registered: July 2005 Junior Member Hi, I'am trying to import a database oracle 9i from a dump generated by EXP. To do that i have created a new instance ... and launched the folowing command : imp system/manager file=intrafor.dmp log=import.log fromuser=intrafor touser=intrafor ignore=Y or imp system/manager file=intrafor.dmp log=import.log full=y ignore=Y and here is the result . importing INTRAFOR's objects into INTRAFOR . . importing table "CB_APPLICATIONS" IMP-00058: ORACLE error 1552 encountered ORA-01552: cannot use system rollback segment for non-system tablespace 'DATA' and after : IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace DATA At the end of the execution (about 8 minutes later), tables are creted but EMPTY ! I have no idea how to solve the problem. Files are accessible (rean & write) ... The rollbacksegment tablespace was created like that : CREATE TABLESPACE RBS DATAFILE '/product/oracle/9.0.1/oradata/oradata/groupama/RBS_01_groupama_01.dbf' SIZE 10M REUSE MINIMUM EXTENT 512K DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096); According to me, the configuration seems to be valid ... but ... Can you guide my search ? Thanks. Report message to a moderator Re: import dump oracle 9i [message #126991 is a reply to message #126982] Thu, 07 July 2005 14:27 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator In 9i , use UNDO tablespace!. Report message to a moderator Re: import dump oracle 9i [message #127045 is a reply to message #126982] Fri, 08 July 2005 03:59 otb82 Messages: 2Registered: July 2005 Junior Member Thanks a lot. I did not know the existance of UNDO tablespace. Report message to a moderator Previous Topic: RMAN hot backup with no archivelogs Next Topic: RMAN restore on unix Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesigner