Copy DBF Into New Server?

Feb 24, 2013

I am using oracle 11g XE.

My server hard disc crashed yesteday and i don't have any backups / I am able to recover the .dbf by using a recovery tool.

is it possible to use this .dbf into new server and recover my data.

View 3 Replies


ADVERTISEMENT

Server Utilities :: Copy Data From One DB To Another?

Mar 15, 2010

we have a prod DB and an Backup DB. I have been asked to copy selected tables from prod Db to anaylsis DB on a weekly basis. Db version is 9i.

Can I use Db links here?, but the data is huge.

View 1 Replies View Related

Server Administration :: How To Copy RAC Database

Feb 2, 2012

how can i copy to a RAC database which managered by ASM to another new host? just as clone.

View 6 Replies View Related

How To Copy Tables And Querys From Client To Server

Feb 28, 2011

im using in oracle program navicat for tables and query. but now i have a problem how copy tables and querys from client to server.

View 1 Replies View Related

SQL & PL/SQL :: Copy Some Archivelog Files Between 2 Database Server

Sep 27, 2011

I wanted to copy some archive log files between 2 DB Server.Steps:

1) Edited the Local and Remote DB's TNSNAMES file and modifyied like below.

bookstore =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.100.28)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BOOKSTORE)
)
)

2) Created a Source Directory --> DR1
3) Created a Target Directory --> DR2
4) Created a DB Link
CREATE DATABASE LINK LINK1 CONNECT TO <username of the Remote DB> IDENTIFIED BY <Password> USING '<Remote DB Name taken in the TNSFILE>.
5) In the Local Server I had written the below command.

create or replace procedure proc1 is
cursor c1 is select recid,substr(name,37) "ARCH_FILE" from v$archived_log;
var1 c1%rowtype;
begin
open c1;
fetch c1 into var1;
[code]...

It is working, but not coping the Files from Local To the Remote.

View 22 Replies View Related

Server Administration :: Copy Many Files From ASM To FileSystem

May 1, 2013

I have got backup pieces in ASM, I guess about more than 100 files. Now, I need to copy all of them from ASM to FileSystem, there are 2 methods still now:

1- Copy from ASM to FileSystem using cp command.
2- Copy from ASM to FileSystem using DBMS_FILE_TRANSFER.

But:

In the first method, when I copy one file, I took more than 1 minute, so the following script would take me more than 1 days (I guess so).

#!/bin/ksh
#
# This script copies files from FRA on ASM to local disk
#
ORACLE_SID=+ASM2
ASMLS=/vasgatedb/app/vsgbkp/asm_ls.txt ##{ASM files list}

[Code]...

The second method, DBMS_FILE_TRANSFER took me less than 1 second to copy one file completely.

sys@VSGDB> set timing on
sys@VSGDB> exec dbms_file_transfer.COPY_FILE('asm_dir','level_0_vsgdb_9998_813844797.bkp','fs_dir','level_0_vsgdb_9998_813844797.bkp');

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.38

Of course, I wish I used the second method as soon as possible, however, said I below, I've got about ~200 files, and I could not copy one by one file.

View 3 Replies View Related

SQL & PL/SQL :: Copy CSV File From Windows Server Shared Path

Jul 12, 2012

I need to copy .CSV File from a Windows Server shared path (\hostnameoutput) to another server which i believe is on unix.The other server name is abc.hcl.com. On this server i need to put it in the root directory. I will have to use SFTP and not FTP.

View 19 Replies View Related

Server Utilities :: Copy Table With NCLOB Column Into Another Database (10g To 11g)?

Dec 4, 2012

I need to copy one table which is having NCLOB column into our new DB(11g) from old DB (10g). As this table having huge records (1 crore) it is difficult to use direct insert statement (INSERT INTO ... SELECT * FROM @remotedb). I don't have DBA privilege to use loader.

View 3 Replies View Related

Server Utilities :: Copy Database On Another Computer Through Local Network

Feb 23, 2012

i've 0racle 9i database, i wanted to know the easiest way how to copy that database on another computer throw local network,

View 15 Replies View Related

Server Utilities :: Copy Table With Special Char Between Oracle 8 And 10?

Nov 17, 2010

I have to copy a table from oracle 8 to oracle 10
- dblink don't work between 8 - 10
- can I dump table ?
- when I try to use sqlload via TXT file, I have error messages due to a column containing 'special' caracters (
,..) and line too long (splitted in several rows)

how can I do ?

View 1 Replies View Related

Forms :: Generate File From Database Into Server And Copy It To Client Machine

Feb 2, 2012

I have a forms that generate a file from database into database server and copy it to client machine by the follow process:

IF webutil_file_transfer.Is_AS_readable(V_server_way || V_file_name) THEN

l_success := webutil_file_transfer.AS_to_Client
(clientFile => :V_screen_way

[code]...

But is showing the erro ora-105100 in one client machine

View 9 Replies View Related

Windows :: Copy A File To DB Server From A Remote Machine Using Plsql / Java

Oct 2, 2013

We want to copy a file from a remote machine to the DB server. copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql

I've used Java and a wrapped it into a PL/SQL procedure so I can do :

exec run_os_command(p_command => 'copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql');

The file was not copied.

I have mapped \<IP_ADRESS>SHARED_FOLDER to x: for example and issued : exec run_os_command(p_command => 'copy x:some_file.sql d:copied_file.sql');

The file was not copied.

But when I issued from the OS prompt copy x:some_file.sql d:copied_file.sql then the file is copied.

What can I add to the PL/SQL procedure so it wil work ?

View 19 Replies View Related

SQL & PL/SQL :: Copy Row With One Value Changed?

Jun 10, 2011

I've got table rep184_mediate with columns

mydate (it should be changed [mydate + 1 day] when copying) and other columns (should be copied as is).

How do I perform this without writing name of each column?

View 3 Replies View Related

Copy On Right Click Not Available On FTP URL

Feb 16, 2013

I had a query that if the ftp service is enabled on a RHEL server, then, why is the right-click on the URL which is like:

ftp://10.101.18.19

does not yield a save-as box? But if I do a ftp to the server like

ftp <server_name>

the mget for a file works.I hope my query is clear that the file cannot be downloaded from the URL but a command line ftp for the file works.revert with the reply to my query.

View 3 Replies View Related

Copy Data Between Databases

Oct 12, 2012

I want copy some tables from one database to another. Which of following is the fastest way:

- INSERT /*+APPEND*/ via database link
- Transportable Tablespaces
- datapump IMP/EXP (I supposed it's the slowest way)

View 2 Replies View Related

Sqlplus Copy Command

Feb 15, 2013

i am trying to copy the data from a remote database which has Oracle 8i thru Sqlplus copy command to the local database which has Oracle 11gR2.

copy from abc/abc@remote
insert emp_new
using
select *
from emp_old
where rownum < 1001;

is it possible to copy the remote database thru sqlplus copy command ?

View 6 Replies View Related

RECOVER / Copy A DATABASE?

Jul 13, 2010

While trying to copy a database, i used the command: RECOVER DATABASE USING BACKUP CONTROLFILE until cancel; it gave:

ORA-00279: change 7866782806751 generated at 07/12/2010 19:39:23 needed for thread 1
ORA-00289: suggestion : /moteurs/oracle/r11110/R11110/archivelog/2010_07_13/o1_mf_1_1158_%u_.arc
ORA-00280: change 7866782806751 for thread 1 is in sequence #1158

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data01/oracle/r11110/data/SYSTEM01.dbf'

ORA-01112: media recovery not started what can i do in this case of issue?

View 5 Replies View Related

Can Copy RMAN To Use Different Database With Different ID

Feb 23, 2011

Can I copy rman to use a different database with a different ID

View 6 Replies View Related

SQL & PL/SQL :: Copy Command In A Procedure

Feb 22, 2010

I got to pull 30M data into local DB from a remote DB. As of now we have procedure to perform this task using an

Insert /*+append*/ table1
select *
from rdb_view;

I observed using the copy command in sql plus has taken very less time than the procedure.Can we use the Copy command inside the PL/SQL block? I tried with dynamic SQL but It is not allowed I guess.

View 16 Replies View Related

SQL & PL/SQL :: Copy Data From Table A To B?

Apr 30, 2010

i could copy data from tableA to tableB with the scenario below

1) Currently we have no unique key / primary key defined on both of this tables, due to the nature of data, so insert/update will not work
2) We cant truncate/insert as user will be accessing this tables when the copying process takes place, so we dont want to end up having a scenario where the table does not contain data at a certain time

Will materialize view full refresh work in refreshing a table so we could avoid the problem faced in point 1 & 2.

View 7 Replies View Related

SQL & PL/SQL :: Copy Data From One Table To Another

Feb 11, 2013

I have two tables namely PERSON and WIFE. I want to make WIFE's data available in PERSON table while keeping entries of WIFE maintained and at the same time adding some the values of PERSON against the data of wife.

PERSON Table
PK NAME ADDRESS IS_MARRIED
1 John ab city Y
2 Varvatos cd town N
3 Smith ef town Y
4 Henry gh city Y
5 Lynda gh city Y

WIFE table

PK PERSON_ID (FK) NAME
1 1 Alice
2 3 Rosy
3 4 Lynda

Now i want to copy data of WIFE table into PERSON table like this PERSON table

PK NAME ADDRESS IS_MARRIED
1 John ab city Y
2 Varvatos cd town N
3 Smith ef town Y
4 Henry gh city Y
5 Lynda gh city Y
6 Alice ab city Y
7 Rosy ef town Y

As in the given example you might have noticed that ADDRESS of wife is same as of her spouse and same goes for IS_MARRIED column. Moreover, the PK is also not duplicated. How to go about this?

Another important factor is Lynda already exits in PERSON table, therefore, i certainly don't want to duplicate her entry.

View 8 Replies View Related

SQL & PL/SQL :: Copy A File From Oraload?

Mar 29, 2011

Iam using Oracle 10g Release 10.1.0.3.0 Database and Linux Operating System for Server. I have a Stored Procedure which generates a Text File in Oraload Folder. Can I copy it to /home/ftp-docs/ using utl_file.fcopy ? If yes, how to do it ?

View 1 Replies View Related

SQL & PL/SQL :: Copy Value In Column To Another Table?

May 21, 2006

Is it possible to copy a value in a column from a table into another column in another table using the select statement.

Example: I want to copy the arrival date from the guest table to date_charge in the charges table.

CREATE TABLE GUEST
(ROOM_NUMBER VARCHAR2(2),
DATE_ARRIVAL DATE DEFAULT SYSDATE NOT NULL);
CREATE TABLE CHARGES
(ROOM_NUMBER VARCHAR2(2),
DATE_CHARGE DATE default Sysdate);

[code]....

View 6 Replies View Related

Sqlplus Copy Insert / Update

May 3, 2013

I have two identical tables from different DB's and I need to copy a row from db1 and insert into db2 if it does not exist or update it if it does(on the tables pk).

This is what i was trying until i realized replace drops the whole table where i thought it dropped the row and inserted the new.

copy
from db1
to db2
replace table2
using
select *
from table1
where x = blah

View 3 Replies View Related

Copy Database From Production To Test?

Feb 22, 2011

Would like to know if I can replicate Production database (10.2.0.2) to Test (10.2.0.4).

tell me the process to do that on windows environment.

I wonder if I can do it with two different oracle versions?

View 4 Replies View Related

Forms :: Concatenate Or Copy Value On Enter Or WVI

May 27, 2013

I have three database fields on my form , field_1 , field_2 and field_3 , user will enter the data in field_1 , and sometime he may not enter in field_2 ,

I want to bring the value of field_1 as it is into field_3 if he does not enter anything in field_2, if he enters the data in field_2 , then field_1 will get concatenated with field_2 and gets copied into field_3.Is there a way to do this automatically at form level using a trigger when-validate-item.In short this should be done after user presses the enter key on field_2.

create table ot_Sale_code_head ( sale_code varchar2(12),code1 varchar2(6),code2 varchar(6),code3 varchar2(12));
insert into ot_Sale_code_head ('A','01.01',NULL,NULL);
--inserted record in form will be 'A','01.01',NULL,'01.01'
insert into ot_Sale_code_head ('B','01.01','PS-P',NULL);
--inserted record in form will be 'B','01.01','PS-P','01.01.PS-P'

View 2 Replies View Related

Forms :: To Copy Data From One Datablock To Another

Jun 18, 2012

I am developing an application for making the travel entries for my organization employees.

For that purpose I have 3 datablocks named:
1) Travel header
2) Employee Detail
3) Travel Detail
which are interlinked through constraints.

I want to give 2 options ie. either single booking entry or Group booking entry.

The form is working properly for single booking entry. But when I want to make a group booking wherein many employees have to travel between common locations I have to fill all the travel details again for all employees. I want to avoid that since it wont give a feasibility for this application. I can copy the travel details I have entered for the 1st employee. I am uploading the form layout.

View 3 Replies View Related

SQL & PL/SQL :: Copy Data At Regular Interval

Mar 2, 2011

I have this remote database A and database B. DB A has 10 views and DB B has 10 tables. I have to pull out data from views of DB A and load into tables of DB B at regular intervals. How do I do this job?

View 3 Replies View Related

SQL & PL/SQL :: BLOB Datatype - Copy From One Column To Another

Mar 11, 2011

I have two tables with BLOB datatype. I am trying to copy from one column to another column , i am getting errors

CREATE OR REPLACE PROCEDURE update_blob_lob_copy(
v_id in integer,
v_string in varchar
)
as
auditlob lobdemoaudit.theblob%type;
sourcelob lobdemo.THEBLOB%type;
[code]...

View 3 Replies View Related

SQL & PL/SQL :: Trigger To Copy Data From One To Another Table

Jun 28, 2010

1. I am inserting a value to a table.through uploading the csv file to the DB table using apex.

2. After the data get inserted into the table(parent),my data should be copied to the another table with some conditions .

3. Is it possible to write a trigger to insert statement from selecting the values from another table.

View 5 Replies View Related







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