I am trying create a database in oracle 9i with (username, pwd) as "system & oracle"I got following error:Checking for existence of required packages...PASSED: Package DBMS_JOB existsPASSED: Synonym DBMS_JOB existsPASSED: EXECUTE privilege granted on DBMS_JOBPASSED: Package DBMS_UTILITY existsPA ...
I have took an transport_tablespace export successfully..( in Linux )while doing an import ( in windows ), i am getting the following error.=======================================IMP-00003: ORACLE error 6550 encounteredORA-06550: line 1, column 7:PLS-00201: identifier 'DBMS_PLUGTS.NEWTABLESPACE' mus ...
I would like to know if it's possible to use the compare_s method of the DBMS_LDAP package on a desactivated user.Each time I'm trying I get an error : erreur : ORA-31202: DBMS_LDAP : Erreur client/serveur LDAP : DSA - refus d'exécution. Erreur de stratégie de compte :9050: GSL_ACCTDISABLED_EXCP : ...
I try to import tablespaces from 10gr2 to 9ir2 and i obtains this error message. Import d'objets SYS dans SYSIMP-00017: Echec de l'instruction suivante avec erreur ORACLE 6550 :"BEGIN sys.dbms_plugts.beginImport ('10.2.0.4.0',31,'2000',6,'AIX-Based Sy""stems (64-bit)',10857,30851,3,0,0,0); END;"IMP- ...
I have two 9.2.0.4 tablespaces where I'm trying transport a tablespace from one 2000 server to another 2000 server. The import immediately fails and kills the Oracle service. On the source database I execute (after putting the users tablespace in read only mode)exp transport_tablespace=y tablespace= ...
I'm trying to transport a tablespace from a 8.1.7 DB (on HPUX system) to a 8.1.7 DB (on Linux system).So I used "export" successfully on the HPUX plateform, I transfered the dump file to the linux machine and then I used the import utility, but then I get this error message :Export file created by E ...
Context: move of a tablespace from a 8.1.7 DB under HPUX to a 8.1.7 DB on linux.I'm continuing on my export/import problem :I'm now having an ORA-19721 error during the import of the tablespace. I've checked on metalink the signification of this error and the possible actions, but everything seems t ...
It's been a while since my last post here, have been quite busy for the past few months. Anyway, I got a question here regarding transportable tablespaceI have an upcoming project which will be a migration from Oracle 8i running on ? platform to Oracle 10g running on RHEL 4 (reason why the first pla ...
I've successfully EXPORTED the metadata of a specific tablespace and copied both it and the tablespace file from the source Oracle 8.1.7 server to my destination Oracle 8.1.7 Server (both running on W2K). When I run the IMP script, I get the following error...any help would be appreciated:Connected ...
OS:HP_UX 11iOracle 9.2.0.3.0 when import tablespace metadata, comand is "imp \'sys/sysadmin AS sysdba\' TRANSPORT_TABLESPACE=y DATAFILES='/oradata/data2/B.dbf' TABLESPACES=A FILE=A.dmp IGNORE=Y LOG=./log/import.log"the error occurs as followed:Export file created by EXPORT:V09.02.00 via conventional ...
export message:Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.3.0 - ProductionExport done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setNote: table data (rows) will not be ...
I exported my database to move to another machine and now when I try to import I get the following:Imported 1,000 rowsImport: Release 9.2.0.3.0 - Production on Wed Mar 3 18:53:41 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Imported 2,000 rowsConnected to: Oracle9i Enterpri ...
I keep on getting ORA-01001 : invalid cursor error while trying to transport a tablespace as a part of TSPITR.Here is how it looks:===================================================C:\>exp parfile=c:\exp_transport.parExport: Release 9.2.0.1.0 - Production on Tue Apr 27 14:47:19 2004Copyright (c) ...
Due to a system crash I lost a 9i database instance for which no backups are available. But datafiles are still on the disk. I installed 10g and tried to re-create some tablespaces (using imp and transport tablespace feature) but failed:Connected to: Oracle Database 10g Enterprise Edition Release 10 ...
Trying to run import of transportable tablespaces:parfile contains:userid="/ as sysdba"file=di_name2_tts.dmplog=di_name2_tts.imptransport_tablespace=Ydatafiles='/fsbackup1/oradata/clonedi/di_name2_idx_part01c.dbf','/fsbackup1/oradata/clonedi/di_name2_idx_part02c.dbf','/fsbackup1/oradata/clonedi/di_n ...
i am using oracle8i on solaris 5.8i am trying to import the tablespace which was in read only mode but i am receiving the following errorhere i given in detail wat i did ....... plz help me to solve this issue.........SQL> alter tablespace hemu read only;Tablespace altered.SQL> select name,ena ...
anyone tell me how to import tablespace as i am repeatedly getting the different error.actually wat i did is during export i made the corresponding tablespace which i am going to export 'read only' and exported successfully.during import i dropped the corresponding tablespace including contents and ...
Had some datafiles (belonging to three diffrent tablespace) corrupted on the development datatabase and was trying to do a tablespace export from the production to the development.But got these errors as it say the tablespace in question is not set to read-only! How come?? Is there any work arround? ...
I am trying to transport tablespaces from 8.1.7.4 to 9.2.0I get a NLS conflict. Export: Release 8.1.7.4.0 - Production on Wed Mar 24 15:13:40 2004(c) Copyright 2000 Oracle Corporation. All rights reserved. Username: / as sysdbaConnected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - ProductionW ...
I tried to import one tablespace into test server. Source server with Oracle 8i and Target server with Oracle database 10g. The error I get is Import: Release 10.2.0.1.0 - Production on Thu Aug 3 00:20:49 2006Copyright (c) 1982, 2005, Oracle. All rights reserved.Username: sys as sysdbaPassword:Conne ...
I'm quite new to Oracle 10g and OCS10g. We have a crippled/corrupt SYSAUX tablespace (data file 3) which cannot be recovered using recover command anymore. So metalink support instructed us to do a export of the metadata of the working tablespace which contains our system data (we are in configurati ...
Oracle 9210HPUX 11.11When I am importing a transport tablespace in my database the statement hangs and it gives no error. For last one day its status has not changed. imp file=/user04/sep06call_13feb07/user_sun/oracle9i/oradata/iobas_sep06/call_data_sep06.dmp parfile=parfile.txtImport: Release 9.2.0 ...
I am trying a imp transportable tablespace from 9i database to 10g. But i am getting following errorExport file created by EXPORT:V09.02.00 via conventional pathAbout to import transportable tablespace(s) metadata...Warning: the objects were exported by SYS, not by youimport done in US7ASCII charact ...
Oracle People,I'm trying to figure out how to import a transportable tablespace I found.The tablespace contains the "sample schema"The export file and corresponding database file look like this: bash sol oracle ~/product/10r2/assistants/dbca/templates 31 $ bash sol oracle ~/product/10r2/assistants/d ...
I have a db on 10.2.0.3.0. I exported it and then tried to load it on 10.2.0.2. It didn't work:IMP-00017: following statement failed with ORACLE error 721:"BEGIN sys.dbms_plugts.checkCompType('COMPATSG','10.2.0.3.0'); END;"IMP-00003: ORACLE error 721 encounteredORA-00721: changes by release 10.2.0.3 ...
hiwhile doing import on x86 platform (solaris 10 - Oracle 10g R3):IMP-00017: following statement failed with ORACLE error 1565:IMP-00003: ORACLE error 1565 encounteredORA-01565: error in identifying file 'whatever.dbf'ORA-27047: unable to read the header block of fileAdditional information: 2ORA-065 ...
For years we exported and imported our transportable tablespaces, but recently the export fails with the following error message:EXP-00008: ORACLE error 29341 encounteredORA-29341: The transportable set is not self-containedORA-06512: at "SYS.DBMS_PLUGTS", line 1143ORA-06512: at line 1EXP-00000: Exp ...
Oracle version 9.2.0.8OS - Windows XPI am doing tablespace transport from one database to another database.My export went good but while importing I am getting some errorsNot only that but I have to restart instance every time I try importC:\>exp userid='sys/**** as sysdba' transport_tablespace=y ...
OS windows 2000 serversame platform in both serversdatabase 10 G NLS_LANG parameter is AMERICAN_AMERICA.WE8MSWIN1252 I have changed this registry parameter to above value then took export of metadata.when I am trying to import tablespace from oracle database 8i to 10 g with following error.Connected ...
I dont know somebody else has posted this error here before, I am sorry If so..I am getting an error when I am transporting tablespace's metadata... can anyone help me about this issue ? My OS is RH 4======================================================================[oracle@localhost export]$ exp ...
I'm trying to run import utility for transportable tablespace concept and here are the errors i'm receiving:IMP-00017: following statement failed with ORACLE error 1565:"BEGIN sys.dbms_plugts.beginImpTablespace('TTS',16,'SYS',1,0,8192,1,802832""6,1,2147483645,8,8,8,0,1,0,8,3961296086,1,34,8027648,NU ...
How I can by pass following error:ORA-29341: The transportable set is not self-containedORA-06512: at "SYS.DBMS_PLUGTS", line 1143ORA-06512: at line 1 ...
I want to transport the tablespace from 9i to 10g but while importing i am facingthe with the folowing IMP-00003: ORACLE error 29339 encounteredORA-29339: tablespace block size 4096 does not match configured block sizesORA-06512: at "SYS.DBMS_PLUGTS", line 1801ORA-06512: at line 1IMP-00000: Import t ...
I try to exp tablespaces from 10.2.0.2 (Enterprise Edition, UNIX) to our test server 10.2.0.1 (express eidtion, linux) with transportable tablespace, when import the tablespaces, get the following error:Export file created by EXPORT:V10.02.01 via conventional pathAbout to import transportable tables ...
Oracle Version : 9.2.0.1Operating System : Windows XPSir. On testing to export a transportable tables space I got the following errors. I am unable to understand the cause of errors. Please guideThe command fired and errors are : Before this I have made the tablespace users read only by this command ...
i am facing problem during import.Source======O/S : LinuxDB : 9.2.0.6.0Target=====O/S : WindowsDB : 9.2.0.6.0The following are the steps done in Source*************************************************[oracle@oraapps ~]$ exp ap/ap tables=(t1,t2,t3,t4) rows=y file=apexp.dmp log=apexp.log grants=n feed ...
I am importing a tablespace using transportable tablespace option. I am importing in another platform which is endian compatible. This is the error I am getting during import. Please let me know the issue. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith ...
I am facing a problem with TTS(Transportable Tablespace).I have a backup of tablespace TBS_DATA as TTS. Now i need to restore that tablespace.Whenever I tried to restore using IMP command below error occured:IMP-00003: ORACLE error 19721 encounteredORA-19721: Cannot find datafile with absolute file ...
10gr2 on windows 2003.SYSAUX datafile is corrupted in our environment and I don't have the necessary archive logs to recover the datafile. Am planning to create a new database and migrate the data there . I tried a) full db export and schema level export fails with the below error : EXP-00056: ORACL ...
We are trying to import table tablespace exported from our source database. We imported the tablespaces in one database successfully. But when trying to import the export dump into another database, the command is failing with below error. What may be cause of this issue?Does import command updates ...
I created new test Oracle 11g r2 database with character set AL32UTF8 and try to create sample schemas in it. To do that I run script mkplug.sql, which uses file /opt/app/oracle/product/11201/assistants/dbca/templates/example.dmp as an export image.The shell variables LANG and NLS_LANG are "C" and " ...
I am trying to tranport a tablespace from one Database to another database.I tried the following steps.I made the tablespace which going to transport as read only.Then I issue the exp command to export the meta data, but throwing following errors,With the Partitioning, OLAP and Data Mining optionsEx ...
I work with Oracle server 8.1.7 .I have one stored procedure , whose construct is importer_remise_transac(p_path varchar2) , which inserts rows from a text file into the database. The argument p_path is the full windows path with the name and extension of the text file.Then I created a stored proced ...
When i trie to use dbms_space_unused_space on IOT table the package returnERREUR à la ligne 1 :ORA-03211: Le segment n'existe pas ou n'est pas dans un état valideORA-06512: à "SYS.DBMS_SPACE", ligne 59ORA-06512: à ligne 19Anybody can help me ...
I'm running the folowing statement : FOR csnap in (select name from all_snapshots where owner= C_SCHEMA ORDER BY name ) LOOP BEGIN DBMS_SNAPSHOT.REFRESH(list=> C_SCHEMA||'.'||csnap.name, method=>'C'); EXCEPTION WHEN OTHERS THEN UTL_FILE.putf(V_FILE,'%s\n', SQLERRM ); END ; END LOOP; But for ta ...
I have a big problem when i run thisdbms_stats.gather_schema_stats(ownname => SC.owner,cascade=>TRUE,options => 'GATHER',DEGREE => 8);I have this errorErreur DBMS_STATS : Err=> -6502 -ERROR- ORA-06502: PL/SQL: numeric or value error: character string buffer too smallSchema => OWB_D ...
This is the message appear when i perform an EXPORT utilitie =================Export fait dans le jeu de car WE8ISO8859P1 et jeu de car NCHAR UTF8Prêt à exporter les utilisateurs spécifiés .... export des actions et objets procéduraux de pré-schemaEXP-00008: Erreur ORACLE 4068 rencontréORA-04 ...
OS: RHL 64Database:10.2.0.4For two days I am struggling with my problem.The issue is that I am trying to do export trasportable using DBMS_DATAPUMP.When I am using DBMS_DATAPUMP in my log I see#################################################Starting "DBA_GRP"."EXP_JOB11":Processing object type TRAN ...
Salut,Je travaille sur un problème de perf, J'utilise oracle version 10.1.0.4.0,En effet j'ai utilisé le hint /*+ gather_plan_statistics */ ensuite j'ai exécute SELECT * FROM table(dbms_xplan.display_cursor(NULL,NULL,'ALLSTATS LAST'));J'ai un message d'erreur ORA-22905: cannot access rows from a ...
I wrote the following procedure Bug_Test as a simple example of what I have in my programs.CREATE OR REPLACE procedure Bug_Test isv_clob clob := empty_clob();v_xmldoc Dbms_Xmldom.Domdocument;v_root Dbms_Xmldom.Domnode;v_node_list Dbms_Xmldom.Domnodelist;v_node_text Dbms_Xmldom.Domnode;v_value number ...