Oracle Error 6550 Set No Outlines
encountered [message #267047] Wed, 12 September 2007 06:20 gautamvv Messages: 254Registered: June 2005 Senior Member I am trying to export and import a table, which has a blob column, and which is a remote machine, so I have copied the information into my tnsnames.ora LINK21 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = oracle) ) ) now when doing this: C:\>exp Export: Release 10.2.0.1.0 - Production on Wed Sep 12 16:41:46 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: cplink21b1_s2/normandy@phlink21 EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 41: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 15: PL/SQL: Statement ignored EXP-00000: Export terminated unsuccessfully C:\> why am i getting this? when i am able to access the same schema with the help of toad Report message to a moderator Re: EXP-00056 Oracle Error 6550 encountered [message #267061 is a reply to message #267047] Wed, 12 September 2007 06:49 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator You exp binary is not compatible with your database. You have to use the exp program with the same version (or lower one) as your database. Regards Michel Report message to a moderator Previous Topic: import error 1438 Next Topic: sqlldr when 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 & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- Other
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 1 2 Previous Next 26 Replies Latest reply on Jun 10, 2011 9:31 AM by Nikolay Ivankin Go http://www.orafaq.com/forum/t/89202/ to original post This content has been marked as final. Show 26 replies 15. Re: Export table with utility oracle 10g 806978 Jun 9, 2011 12:38 PM (in response to Nikolay Ivankin) What about this? I tried just to export one table from my actual database: exp user/pas@tns FILE=OHS_CR.dmp TABLES=(OK_ARCH_CHS_CR_201195)I get this Export: Release 10.2.0.1.0 - https://community.oracle.com/thread/2237312?start=15&tstart=0 Production on Thu Jun 9 14:35:58 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 41: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 15: PL/SQL: Statement ignored EXP-00000: Export terminated unsuccessfullywhat does this mean? Like Show 0 Likes(0) Actions 16. Re: Export table with utility oracle 10g Nikolay Ivankin Jun 9, 2011 12:43 PM (in response to 806978) Pupli_p wrote: What about this? I tried just to export one table from my actual database: exp user/pas@tns FILE=OHS_CR.dmp TABLES=(OK_ARCH_CHS_CR_201195)exp user/pas@tns DUMPFILE =OHS_CR.dmp TABLES=(OK_ARCH_CHS_CR_201195) DIRECTORY= When you use dumpfiles then you must add directory clause. Like Show 0 Likes(0) Actions 17. Re: Export table with utility oracle 10g 806978 Jun 9, 2011 2:06 PM (in response to Nikolay Ivankin) exp user/pas@tns DUMPFILE=OK_CHS_CR.dmp TABLES=(OK_ARCH_CHS_CR_201195) directory=TP_EXP_OK LRM-00101: unknown parameter name 'DUMPFILE' EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help EXP-00000: Export terminated unsuccessfullyafter that: C:\Documents and Settings\Administrator>exp help Export: Release 10.2.0.1.0 - Production on Thu J
2000 And Export Dump is taken from Oracle 10g rel2 , Win Xp Professional the Following Errors are given, IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: Read more 2013-03-30 16:09 Oracle Getting error while http://www.cornbio.com/oracle-set-no-outlines-error-while-importing/ Importing the Application I am Getting Problem While Importing the Application We are moving the Application from Test enivorment to Production Environment, Both are Oracle 10g with HTTP server and Application Express 3.2.1. While Importing i am getting Error like. Error repo Read more 2015-03-15 18:26 Oracle Getting error while import data pump is running We are trying to import data in 10gR2 version through impdp utility. Everything is oracle error working fine except while importing stats for the tables giving below error. We tried with dbms_stats.gather_table_stats same error is coming. Please suggest. Thank u Read more 2015-04-16 08:16 Oracle Reg:error while importing While importing a dump file from a database, i hav got an error regarding archive logs and import terminated. I would like 2 know the purpose of archive log. how to disable archive log. Read more 2014-02-09 06:20 oracle error 6550 Oracle NULL error while importing the data Hai everybody. In one of our branches there was some problem. To simulate the situation. i advised them to send the backupdata. While importing data from a dump file, i am getting the erro message "cannot insert NULL into (“APGB5168”. “D010014”. “LBR Read more 2013-02-27 20:48 Oracle Unusual error while importing using Import: Release 10.2.0.1.0 I am getting an error that I have never encountered before during an import. It is ORA-01403: no data found. As stated in the "Subject" I am doing the import using Import: Release 10.2.0.1.0 and am importing into a 10g database. The first few lines o Read more 2012-11-21 06:04 Oracle Getting error while importing a table partition I am trying to import a table partition from OEM and occurred with following error: Job IMPORT000042 has been reopened at Friday, 13 June, 2008 14:44 Restarting "SYSMAN"."IMPORT000042": Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/T Read more 2012-06-03 20:19 Oracle Error while Importing SYSTEM objects into 9.2.0.6 I got the following error while importing data into 9.2.0.6 DB . It is related to a SYSTEM object. . importing SYSTEM's objects into SYSTEM IMP-00017: following statement failed with ORACLE error 2270: "ALTER TABLE "DEF$_CALLDEST" ADD CONSTRAINT "DEF Read more 2014-02-16