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?
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
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.
I would like to know if 'user creation definition' is exported in user mode export if export is done with DBA role..If it is Not, does it mean we always need to precreate the user before we import the dump created using 'user mode export'?
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]...
I want to create such a script to clone the Database user with the new name. Just like we do normal import and export I want that i should enter just the username of the existing user and username of the new user I want to get created, the password for the same.
It should create the new user with all roles and the default roles and privileges of old user.
we have every day full export backup in eacly morning. but some tables's data has been delete unforutnaltely & structure of these tables intact. how do i import only some tables of a user from
daily full export backup? . this has to be done immdediately.
I am trying to take backup of the user tstcvs of cvmdb database but it fails due to some reason [oracle@cvs ~]$ exp
Export: Release 10.2.0.1.0 - Production on Tue Jan 3 12:37:06 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: sys/sysdba@cvsdbm as sysdba
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Enter array fetch buffer size: 4096 >
Export file: expdat.dmp > 3-1-12-tstcvs
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 2
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified users ... User to be exported: (RETURN to quit) > tstcvs
User to be exported: (RETURN to quit) >
. exporting pre-schema procedural objects and actions . exporting foreign function library names for user TSTCVS . exporting PUBLIC type synonyms . exporting private type synonyms
I am importing a dump into 11g Database, the dump taken from Old Financial release 6 [EBIZ]
i given this command:
IMP FILE=EXPDUMP.DMP BUFFER=524288000 FULL=Y IGNORE=Y Import user system and password given...
Once its started and getting error
+"ALTER USER "PERFUSER" QUOTA UNLIMITED ON "OTHERD""+ IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'PERFUSER' does not exist
[Code]....
what is the wrong,,
I have created all the data files same like Old Database. so while importing All the USERs will created, if its correct then why this "*ORA-01435 : User does not exist*" coming...
Our Testing DB is running in No archive log mode. I did a schema level import by dropping the existing user that contain tables, recreate the user and finished the import. Now they want the old tables back.Is there is any way to recover the old tables?
I have dump file of 17 GB,which i want to import in my database db1 in user amol ;so i created new user under db1 as below ,before this i have created tablespace so that i can import my data only to that tablespace only. My steps are as below.
create user amol identified by amol default tablespace ptaxold1 temporary tablespace tem; imp amol/amol then i mentioned my dump file but after importing it does not show any table under user amol.
I have a strange problem when creating a view in user from another user
I have a user called "Cash_tst"
its syntax creation is
-- Create the user create user CASH_TST identified by "" default tablespace CASH temporary tablespace TEMP profile DEFAULT quota unlimited on cash; -- Grant/Revoke object privileges grant connect to CASH_TST; grant dba to CASH_TST; grant resource to CASH_TST;
-- Grant/Revoke system privileges grant create any view to CASH_TST; grant unlimited tablespace to CASH_TST;
I want to create a view
CREATE VIEW TAMER AS SELECT * FROM [b]AROFL[/b].RA_CUSTOMER_TRX_LINES_ALL_BEFO
"AROFL" is another user on the same database when try to create the view "tamer" i got message of "insufficent privilege" although i granted "create any view" to the user "cash_tst"
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;
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 ###########################################
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