Server Utilities :: SYS.DBMS_EXPORT_EXTENSION Does Not Exist
Dec 30, 2002
I have Oracle 8.0.5 running on Windows NT 2000 Server.While trying to export tables using @ORACLE_HOMEbinexp80 I get the following error.
I must mention that I ran the catproc.sql script and utlrp.sql. However I'm getting 191 invalid objects when running:
select object_name, object_type, status, owner from dba_objects where status='INVALID';
Here is the exception
--------------------------------------------
. . exporting table IMDTB_DOCS
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_EXPORT_EXTENSION" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
View 3 Replies
ADVERTISEMENT
Oct 19, 2010
i prepare database server and when i import my dump file from old database it import normal but before it end it give me these errors and these errors it seems that it in loop
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 12:
PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
View 8 Replies
View Related
May 25, 2010
I'm trying to move a complete tablespace with all associated schemas/users and data.
The command that I'm using is as follows:
impdp DP_USER/DP_USER directory=datapumps network_link=backup tablespaces=SDE
DP_USER has the IMP/EXP_FULL_DATABASE, as does the target of the database link.
The error that I get is the following:
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"SDE"."VERSION" failed to create with error:
ORA-01918: user 'SDE' does not exist
The SDE tablespace has objects from the SDE schema, but the SDE schema does not seem to be created along with the tablespace. How do I cause it to be?
View 9 Replies
View Related
Jul 22, 2004
i imported a .dmp file but i got this error:
Connected to: Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully
Then i run the catexp.sql using SYS user. But i still got that error.
View 20 Replies
View Related
Sep 26, 2011
Does It can not shrink in manual space managment tablespace?
I was confused by the error ORA-10637: The segment does not exist
create tablespace test_manual
datafile 'd:oracleoradataorcl est_manual.dbf' size 100m
segment space management manual
create user test_man identified by hxl
default tablespace test_manual;
grant create session to test_man;
grant resource to test_man;
[code]....
View 3 Replies
View Related
Jul 6, 2011
I wanna know the way to count connections exist on Database, and the max connections db accept.
View 14 Replies
View Related
Feb 23, 2012
how to find the versions of exp and imp utilities of database server from windows command prompt?
Note: Currently i have 10.2.0.10 oracle software installed on my local machine.
View 4 Replies
View Related
Jan 17, 2013
i did this step
C:UsersAdministrator>sqlplus
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 17 15:59:33 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: sys@orcl as sysdba
Enter password:
Connected to an idle instance.
SQL> create pfile from spfile;
[code].....
here its my init.ora file
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
[code].....
View 7 Replies
View Related
Sep 16, 2003
All of a sudden my oracle application has stopped functioning.When I try to log in I get the following messages:
ORA-27101 SHARED MEMORY REALM DOES NOT EXIST
ORA-01034 ORACLE NOT AVAILABLE
From the command line when I try to connect as sysdba and startup the following message appears: "oracle instance terminated.Disconnection forced"
View 18 Replies
View Related
Jun 6, 2011
Im facing the problem whenever I try to drop a user. Following thing that I m trying..
system@vahan> drop user knp cascade;
Error at line 1:
ORA-00604: error occured at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7
View 4 Replies
View Related
May 29, 2013
I have one doubt on Expdp & RMAN. Do EXPDP utilities does backup at block level as what RMAN is doing? Which one is faster, expdp or RMAN?
View 16 Replies
View Related
Sep 24, 2013
i am continuously inserting data to oracle database after some time like 2 hours oracle disconnects,it creates erros like
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
after restarting the database with shutdown immediate ans startup if i start inserting records it will show erros like
ORA-01653: unable to extend table SYSTEM.GLT_PROT_TRAFFIC_SUM_VOIP by 8192 in tablespace GLCOMM
but i have created the Tablespace with BigFile Auto Extend and max size unlimited, i am having 400GB disk space created Redo logs with 15gb,i have tried serveral times reinstalling the oracle but problem is not solved.
same problem is happenging with small datafiles also,
operating system: windows server 2008 R2 standard
oracle server : 11g
oracle client : 64 bit
View 14 Replies
View Related
Oct 29, 2013
I want to load lakhs of records into a table. My problem is when after loading the ¼ of records my process is abend due to the size of my rollback segment area. I don't have an option to increase it. So, Is there any way to go for intermediate commits when I am using the imp or sqlldr utilities to load the entire data without abend?
View 2 Replies
View Related
Feb 20, 2012
I am familiar with tool Netca. However there is one more utility exist for the same functionatlty which is netmgrI checked with many DBAs for the exact difference, however I did not get the best answer from them. I also have checked in google but not exactly got the difference. list the exact difference between those 2 tools (netca, netmgr)
View 1 Replies
View Related
Mar 24, 2010
How to execute the SQLLDR, where Data File Reside in another Server?
View 1 Replies
View Related
Sep 15, 2010
I have exported data of one user an importing into another schema at another server. when i am trying to imoport it is working fine for quite no of imports into tables, but after some time it starts giving me below mention error...
IMP-00008: unrecognized statement in the export file:
<
IMP-00008: unrecognized statement in the export file:
<
IMP-00008: unrecognized statement in the export file:
<ے
IMP-00008: unrecognized statement in the export file:
+A
IMP-00008: unrecognized statement in the export file:
[code]...
View 6 Replies
View Related
Nov 23, 2011
I have a requirement to read flat text file(around 15000 lines) residing at a client location from DB server and write into a table in One cell.
I tried UTL_FILE and DBMS_LOB but, i am not able to access client location to read the file as it reads path from Oracle Directory.
eg.
my client path is 198.168.1.1 and my DB server is in unix say 192.168.1.10.
file location is: \192.168.1.1shareabc.txt
So I created One Oracle directory as MY_DIR having DIRECTORY_PATH as '\192.168.1.1share'.
But both UTL_FILE and DBMS_LOB is not able to access the file.
Error Message:
-------------
Unable to process CLOB -22288 ~ ORA-22288: file or LOB operation FILEOPEN
failed
No such file or directory
Few Details for reference:
-------------------------
File Location: \192.168.1.1shareabc.txt
Unix DB Server location: 192.168.1.10
Table : Test (filename varchar2(30), Content CLOB)
Oracle Dir: MYDIR
Directory_Path: \192.168.1.1share
View 7 Replies
View Related
Mar 16, 2011
I've a question regarding difference of character sets, while taking a export(logical backup) of database on directly to server(linux RHEL 2.1 AS) and export on a client (windows xp prof machine, where only a oracle 9i client is installed). On server it seems to fine and okay, but on client node i'm getting following error for almost all tables.
EXP-00091: Exporting questionable statistics.
My question is :
[1] Is it creating any sort of problem, if later on i import the data which was taken from client node.
[2] Why there is a difference(marginal) in dump(.dmp) file size.
[3] Is there any way to overcome it, or it is the natural behave of it. Means not a problem.
[4] If i'm using a long or blob as datatype for some of my table,is they have any problem if i persist like above.
Additional Information about character sets On server node :
Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion)
On client node :
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set server uses US7ASCII character set (possible charset conversion)
View 7 Replies
View Related
Mar 7, 2011
I'm importing data from SQL Server to Oracle. I used BCP to export the data from SQL Server. Below is the 1st record of table trlc from the csv file.
trlc.CSV
11032|100|Wman| | |2008-02-08| |
Using SQL Loader to import into Oracle:
TRLC table in Oracle database:
est_no varchar2(10) default ' '
right_no number(4) default 0
maj_auth varchar2(15) default ' '
weight varchar2(10) default ' '
idm_ht varchar2(8) default ' '
c_date date
P_tkt varchar2(5) default ' '
sqlldr user/pwd@db02 control=trlc.ctl log=trlc.log
trlc.ctL:
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?
View 12 Replies
View Related
Jul 11, 2011
Here are the cards I've been dealt:
I've inherited a 10.2.0.1.0 instance running on a windows 2003 box; running fine, no problems other than system has been in production since 2005 and has gotten pretty old and tired. This old box has one tablespace on it... called "gateway".
I've installed 11.2.0.1 on a new (Windows 2008 R2 Enterprise 64-bit) server and created an empty database also called "gateway".
Now to move the data and views, objects, everything.
I've read up on a variety of migration techniques (oops, I mean "upgradation" LOL) and can follow the steps...
In short, I want to pull everything off of server a (10.2) and put it into production on server b (11.2). There seems to be quit a few options.
1. install 10.2 on my NEW server (server b), move the data over and get everything running, then install 11.2 and have it upgrade the database as part of the installation process.
2. drop the empty tablespace on server b, stop the database on server a, copy the files over from the old to the new home, run DBUA or set the compatibility attribute...
3. run some type of server a to server b utility that can bridge the two over the network. Some type of mirroring technique?
4. run file export scripts on server a, copy files to server b and run various import scripts
I tend to think that option 3 would be the best because both instances are in great health and are running right now. Is there a mechanism that allows the 11.2 instance to see and upgrade from a different server?
View 9 Replies
View Related
Feb 2, 2011
any other utilities that we can use to load data from our PROD server (10g) to DEV server (9i)? I've read some related topics here that it's not possible to import from a HIGHER to LOWER versions of Oracle. We've tried (many times) EXPorting selected tables from the 10g dB, then IMPort it to the 9i dB and we've haven't succeeded anyhow. PROD & DEV have a different schema/owner but the same table structures.
View 4 Replies
View Related
Jun 8, 2011
I have lot of problem using 11G and i dont want to continue trying to repair them all. I just want to do a full DMP Export from 11G DB and Import into 10G.
The reason? No problems when using 10G before.
I try using the oracle export tool on the 11G DB, but when i try to import into 10G there's a header problem. I guess that, like in other oracle DB version, the 11G DMP isnt compatible whit the 10G import tool.
View 7 Replies
View Related
Jun 19, 2010
I have oracle 9i dump...now i want to import this dump into oracle 10g.....is it possible.
View 4 Replies
View Related
May 31, 2012
For migrating the database version 10.2.0.3 on Windows to version 11.2.0.3 on Linux i am using the transportable tablespace option.After the import of metadata and copy of tablespace datafiles to destination the sequences and functions are not available. Does it work if i later export and import the sequences and functions separately ?
View 1 Replies
View Related
Oct 27, 2010
i was created this same thread in Dba-village. i need to attache my log file
i want to upgrade my database 8i to 10g, for testing purpose i install 10g with started database and i created needed users and i import using dump
imp system/passwd file=dumpfile.dmp log=logfile.log rows=y ignore=y statistics=none full=y
the log file gave some errors and warnings i will attach my log file
View 5 Replies
View Related
Jun 15, 2011
I am trying to use the export the database using datapump API dbms_datapump.I want to export the entire database excluding some schemas.
My question is how to exclude some schemas using datapump API?
View 1 Replies
View Related
Nov 23, 2005
I have a problem that goes like this. My senior sent me the recent dumps of our database from production. He told me that dont drop the tablespaces and users in order to save time of re-creation. He told me told me to drop the objects of individual users. Now, i have dropped the objects of XDB oracle's default schema which is required for XML support functions.
How to export the XDB schema from another database with the same version and re-store in the present database.Whenever I try to take the export of XDB user from other database I get error user does not exist. I have checked in the console it is locked.
Now, how do i restore the XDB schema.
View 12 Replies
View Related
Oct 23, 2011
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:UsersAdministrator>d:
D:>imp
Import: Release 10.2.0.1.0 - Production on Mon Oct 24 08:45:48 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
[code]...
IMP-00058: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
IMP-00000: Import terminated unsuccessfully
View 10 Replies
View Related
Feb 4, 2011
I installed oracle 10G complete so I can have everything. But now I cannot run sql loader. I check my oracle devsuitehome directory and I cannot find sqlldr.exe
I need to install sql loader separately? I can't find sql loader installer on web.
View 3 Replies
View Related
Mar 22, 2012
I have two tables of same structure i.e., DEV & HET.
I need to export from DEV and import into HET, I am using REMAP_TABLE while IMPDP, but data is getting inserted into DEV itself. Below are the syntax for expdp and impdp
Export from Dev:
expdp sunnyworkspace/sunnyworkspace@orcl directory=REMAP_DATAPUMP version = 11.1.0.6.0 dumpfile=dev.dmp tables=sunnyworkspace.dev reuse_dumpfiles=y CONTENT=DATA_ONLY
Import to Het:
impdp sunnyworkspace/sunny
workspace@orcl directory=REMAP_DATAPUMP version = 11.1.0.6.0 dumpfile=dev.dmp tables = sunnyworkspace.dev remap_table=sunnyworkspace.dev:het
View 11 Replies
View Related
