Server Utilities :: Moving Database Using Exp / Imp?

Sep 23, 2010

I need to move database ORCL into our existing central database CNTR (both are on same OS and oracle version) I started exp each schema from ORCL and imp in CNTR.

But there is one schema EXMP in database ORCL which also exists in CNTR database with same tables, indexes . The data under schema EXMP in ORCL should be added to schema EXMP in CNTR.

View 9 Replies


ADVERTISEMENT

Server Utilities :: Moving Database 9i To 10g New Hardware?

Jun 18, 2010

I want to move oracle database 9i on win server 2003 32-bit to be oracle database 10g R2 on win server 2003 64-bit on a new hardware.

View 2 Replies View Related

Server Administration :: Moving 10 GB Data To 200 GB Database Server

Jun 22, 2011

We have an Oracle Server database of Size 50 GB having 10 GB Data. And Planning to have a new Database Server of 200GB . So my question is after moving all the 10 GB data to 200 GB Database Server, will the performance of the system come down? Will it reduce the speed?

View 9 Replies View Related

SQL & PL/SQL :: Moving Images From Server To Oracle Database?

Jun 28, 2011

I have a problem(illega use of LONG) while moving image data from SQL Server 2005 database to Oracle10G table in BLOB.

insert into table
select [[mailto:.....tablename@odbc SQL|.....tablename@odbc_SQL]]

I am using HS connection and DBLink.

View 10 Replies View Related

Server Administration :: Moving IT_TO_DUM_LOADING Job From G1 Database To G2?

Jun 17, 2011

I want to move IT_TO_DUM_LOADING job from G1 database to G2 database.

I executed the below query and returned one row with jobname IT_TO_DUM_LOADING.

SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_CREATOR, CLIENT_ID,
GLOBAL_UID, PROGRAM_OWNER, PROGRAM_NAME, JOB_TYPE, JOB_ACTION,
NUMBER_OF_ARGUMENTS,
SCHEDULE_OWNER, SCHEDULE_NAME, SCHEDULE_TYPE, TO_CHAR(START_DATE,'DD-MON-YYYY') START_DATE,

[code]....

it returned the result with

owner,
job_name=IT_TO_DUM_LOADING
job_creator='BALA'
job_type=stored_procedure
job_action='DUM_IT_LOAD'
schedule_type=calendar
start_date='12-JUNE-2008

[code]....

I could not find this job in dba_jobs. how to move this job from one database to other database?

View 23 Replies View Related

Server Utilities :: Finding Versions Of Exp And Imp Utilities Of Database Server?

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

Server Utilities :: Import Table From Another Database By Using Database Link?

Mar 17, 2010

i would like to import a table from another database by using database link.

impdp muba/muba tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1

i created the public database link as system user

it gave error like

Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:07:02
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Starting "MUBA"."SYS_IMPORT_TABLE_01": muba/******** tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

[code]....

after that i try to import as system user like

impdp system/passwd tables=FUNCTION_NO schemas=muba directory=testdump NETWORK_LINK=DBLINK1

but error like

Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:27:43
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
UDI-00010: multiple job modes requested, schema and tables.

when i use IMP utility

imp system/passwd file=dump.dmp fromuser=userA touser=userB log=dmplog.log but when i use IMPDP what is the parameter equal to fromuser & touser

View 3 Replies View Related

Moving From 1 Database To Another

Jul 25, 2013

I need to move everything from database 'X' to database 'Y' (assume: both are Oracle 11.2).Which should be the most appropriate way to achieve that?I thought of Transportable Tablespaces- URL..... but I'm worried about it's limitations especially this:SYSTEM Tablespace Objects - You cannot transport the SYSTEM tablespace or objects owned by the user SYS. Some examples of such objects are PL/SQL, Java classes, callouts, views, synonyms, users, privileges, dimensions, directories, and sequences This means all PL/SQL code- Packages/Procs/Functions will be affected. 

View 27 Replies View Related

Moving Datafiles Between Database

Oct 31, 2012

I read this article:

[URL]......

Does it work with copying datafiles from 10g2 to 11g2? I want to move one huge tablespace (which contains one table) from 10g2 to 11g2, what is the best method to do that?

View 3 Replies View Related

Server Utilities :: Import Whole Database To Another Database

Dec 7, 2011

Is it possible to import one whole database in to another whole database?

View 4 Replies View Related

Moving Files On Physical Standby Database?

Oct 19, 2011

We're currently in a situation where the primary database server fs size does not match the standby database server fs size.

Standby database filesystem is almost 100% utilized, and we suggested to move some of the datafiles first to avoid threshold alerts and archive gaps.

Now, if we're gonna move datafiles on the physical standby, I believe the process would be stop managed redo apply -> shutdown standby -> OS move -> startup mount -> alter rename -> start managed redo apply. Is this correct? If not, how?

Also, would it have an effect if the controlfiles of primary and standby do not match because of the movement?

View 1 Replies View Related

Moving Databases To New Host Server?

Oct 7, 2012

I have a requirement to move the databases to a new server.

Existing set up:

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.2
OS - UNIX AIX-5.3

New Server (setup):

database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.3
OS - UNIX AIX-6.1

My query is what is the best way to move the database to new server(UNIX AIX 6.1)?

a) can i upgrade the database to 11.2.0.3 before moving to new server or its better to move the database in 11.2.0.2 and then upgrade there?

b)is export and import of database can work for moving this?

c) RMAN backup and restoration can be done for moving databases?

d)simply moving all the related files to new server and start upgrading it from there?

View 8 Replies View Related

Server Administration :: Moving OMF Files In ASM

Mar 13, 2013

The steps to move OMF files in ASM. I tried the following and was not successful.

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/system.357.809972853"
datafile 2 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/sysaux.363.809972837"
datafile 3 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs1.365.809972737"
datafile 4 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/users.361.809972859"
datafile 5 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs2.360.809972761"
datafile 6 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs3.359.809972787"
datafile 7 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs4.358.809972811"

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/13/2013 16:30:05
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

RMAN> alter database open;

so switch worked reset logs says can't use it there so I just try to open and it just hangs.

View 1 Replies View Related

Backup & Recovery :: Moving 9i DB To New Server

Jul 2, 2012

I've inherited a DB where they are going to do a restore this weekend.

The current DB admin is using a db restore (not a duplicate). RMAN with no catalog. The current issue is that the DB restores fine, but when we do a delete obsolete after our backups it's asking if we want to delete the data files.

View 13 Replies View Related

Server Utilities :: How To Import A Database

May 22, 2011

I do not import a full database.

View 3 Replies View Related

Server Utilities :: Exporting Database?

May 31, 2010

I am Trying to Export my database and whenever I try to login it is giving Ora-Error 1017 Invalid Username/Password.

If I Login as System and Manager it is accepting but I am not able to Export all my Database.

View 9 Replies View Related

Server Utilities :: Reg Database Directory

Feb 12, 2013

On last week we have migrated our oracle database from 9i to 10g through imp utility ,but now i have facing one small issue where as new have our old live database with us and suppose we have fired

"SELECT* FROM V$PARAMETER WHERE NAME LIKE 'utl%'"

to check directory name and valus then in output its shown name:-utl_file_dir and valus:-E:RAB but in our new database its does not shown any value like E:RAB in migrated database as i have recreated that directory in new database but still that issue persist .

View 3 Replies View Related

Moving From 32 Bit Linux To 64 Bit Windows Version On Database Standard Edition

Aug 16, 2013

when migrating from  32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of? 

View 2 Replies View Related

Moving Schema From One Database To Another Of Different Unix Flavour With Minimal Downtime

Aug 14, 2013

Oracle version : 10g, 11g (applicable to both) Consider a schema named 'UNIVERSE' present in the database A running on Linux platform where this schema needs to be moved to another database B running on  windows platform or AIX platform with no downtime provided and data needs to be consistent.  Is this practically possible?

View 13 Replies View Related

Server Administration :: Moving Tables From Older To New DB?

Mar 23, 2013

I have problem with moving old DB to the new (the same DB 10.2.0 in Win 2003, first in 32 bit, second in 64 bit). I want move DB from 32 to 64 bit. Problem is that all objects in old DB were created in SYSTEM schema by SYS. I can't export that objets (with data) because impdp nor imp don't touch this objects (tables with indexes). I can't use export import procedure. I'm looking for another method to transfer data, which will be the best and the fastest? Maybe files copy on OS? I suppose it will be problems with configuration files, database have other tablespaces.

View 13 Replies View Related

Server Utilities :: Move Objects From One Database To Another?

Jun 2, 2011

I want to move 350 database objects from one database to another database schema.

View 16 Replies View Related

Server Utilities :: Importing Full Database With Different Name And Sid

Oct 20, 2011

Source:Oracle 11g 11.1.0.2 32 bit on Windows 2003,Destination: Oracle 11g 11.1.0.2 64 bit on Windows 2008

In our Source Database, we are using following to create full export

Source database_name=dbfour,sid=dbfour1

I am creating full export by using following

expdp system/psswd full=y dumpfile=expdp_%date:~0,2%-%date:~3,2%-%date:~6,4%.dmp logfile=explog_%date:~0,2%-%date:~3,2%-%date:~6,4%.log FLASHBACK_TIME="to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')"

In my destination DB with database_name=dbfive and sid=dbfive1, i am trying to import whole database by using the file created above and use following

impdp system/pwd@dbfive DIRECTORY=DATA_PUMP_DIR DUMPFILE=EXPDP_20-10-2011.DMP

Process started but after sometime it gave 1200 errors. Is it due to the Different Database name or Is it because i did not create table space in destination database.

View 3 Replies View Related

Server Utilities :: How To Import DMP File To Database

Apr 30, 2012

I am trying to import .dmp file to my database

I am trying to run the imp command from dos prompt.

Here is the error I got .

C:Documents and SettingssairammMy Documentsartmsexp_AUDT2_04292012>imp
sairamm/mypassword@aws fromuser=AUDT2 toUSER=SAIRAMM file=exp_AUDT2_04292012.dmp
log=imp_AUDT2_04292012.log BUFFE
R=10000000 GRANTS=y
Import: Release 9.2.0.1.0 - Production on Mon Apr 30 14:23:29 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing option

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

View 2 Replies View Related

Server Utilities :: Database Installation Using ASM In DBCA

Mar 6, 2010

I have installed asm lib and asm instance has started successfully and is working if i am using

EXPORT ORACLE_SID=+ASM

but if I am using DBCA after that to create database on ASM activated disk group I am having problem in creation of spfile. How to follow steps to create database using already installed /mounted disk group with DBCA.

View 1 Replies View Related

Server Utilities :: Clone Database User

Aug 1, 2011

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.

View 39 Replies View Related

Server Utilities :: Unable To Import 3 Different Database

Jan 22, 2013

I need to import one schema into 3 different DBS. out of 3, have imported into 2 databases without any error. during 3rd import iam getting below error:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP and Data Mining options.
ORA-31626: job does not exist
[code]....

I am using same parfile. no changes on the syntax. this is a schema export.

---partfile content
> more QSHOUT_ALARMPOINT4_import.par
directory=APP_EXPORT
dumpfile=exp_PSHOUT_01182013_ALARMPOINT4_SCHEMA.dmp
logfile=exp_PSHOUT_01182013_ALARMPOINT4_SCHEMA_impQSHOUT.log
TABLE_EXISTS_ACTION=truncate
parallel=2
cluster=n
full=y

View 6 Replies View Related

Server Utilities :: Imp / Exp Using RMAN Duplicate Database

Apr 23, 2010

I try to use rman duplicate database to bring entire databse form Windows XP system to another Windows XP. I have been trying to use rmain duplicate database without success.

I failed on "startup force nomount......". The system always prompt me an error as "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" and following by TNSLSNR.exe has encountered a problem and need to be close......"

I have tried to re-install the oracle multiple times and failed at the same problem as above. So, I am thinking of using imp and exp to do the work. Is it possible? If yes, how to do it.

View 5 Replies View Related

Server Utilities :: Import 9i Dumpfile Into 10g Database?

Aug 6, 2011

Is it possible to import a 9i dumpfile (taken by tradition export method) into 10g database using datapump import?

9i and 10g are database version

View 7 Replies View Related

Server Utilities :: How To Export / Import Database On Different Network

Sep 29, 2010

I want to create two or three sachems on my production server which should be the same copy of my another second production server. And I access this second server through VPN connection on toad9.0.1. And I access my production server through VNC viewer and database through toad.

How cloud I create schema on my first prod. server from second server.

View 11 Replies View Related

Server Utilities :: Load JPG Picture Into Oracle Database?

Jun 8, 2011

i want to load jpg into my oracle database 10g throw sqlloader

i did folloing steps

step 1)

Create the table as follows

CREATE TABLE image_table (file_id NUMBER(5),
file_name VARCHAR2(30),file_data BLOB);

step 2 )

Create control file as follows

LOAD DATA
INFILE *
INTO TABLE image_table
REPLACE
FIELDS TERMINATED BY ','
(

[code].....

step 3)

Then i have run this command

F:oracleproduct10.2.0db_1in>sqlldr control=F:practicecontrol.ctl
Username:system
Password
so i got this error
SQL*Loader: Release 10.2.0.5.0 - Production on Wed Jun 8 13:47:27 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-404: Column FILE_ID present more than once in IMAGE_TABLE's INTO TABL
E block.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved