How To Delete SID Name (oracle) From Computer

Oct 29, 2010

How to delete SID name (oracle) from my computer ?

View 7 Replies


ADVERTISEMENT

Windows :: Oracle Developer 6i And 10g On Computer?

Dec 2, 2011

How I can install and use Oracle Developer 6i and Oracle Developer Suite 10g on the computer? It needed registry edition or is there any "official" way?

View 1 Replies View Related

Windows :: Install Oracle R12 On Computer?

Sep 18, 2012

I need steps to install Oracle R12 on my Windows computer.

View 1 Replies View Related

Switch To Oracle DBA From Non Computer Science Background

Aug 16, 2010

I am on H1 visa and working as chemical engineer...but I am bored of this job... I wanted to switch to IT and particularly oracle dba..

How much is the risk for me as I am coming from non computer science background..there are various IT consulting companies who can provide training and do h1 transfer......currently (year 2010) the market for oracle is booming a lot...so I was thinking what can go wrong if I do this switch.

View 1 Replies View Related

Oracle 10g - Loading In Computer Select Statements Say No Data Found?

Jun 7, 2011

I am using oracle 10g i have a table on my computer that i made for a friend when i load it on their computer the select statements say no data found if i use select * from table name all the data will show

if a column name select * from table name where duty_date = '05-JAN-11'no data found

View 1 Replies View Related

PL/SQL :: To Delete Child Records Manually Without Using Oracle Delete Cascade

Oct 9, 2012

I have to write a procedure that accepts schema name, table name and column value as parameters....I knew that i need to use metadata to do that deleting manually.

View 9 Replies View Related

How To Completely Remove 11g From Computer

Mar 12, 2011

how to Completely remove Oracle 11g from my computer ?

View 2 Replies View Related

Should DBConsole Be Crashing Computer

Nov 23, 2010

I have Oracle 11g downloaded on my laptop for personal use. Here are my specs-

Gateway T-6815
Processor: Intel® Core™2 Duo CPU T5250 @1.5GHz 1.50 GHz
RAM: 1.00 G
32-bit Operating System
Windows Vista -Home Premium
Disk Space Available : 16.8 GB free of 138 GB

Every time I start DBConsole it takes almost 30 minutes to start, slows down the computer to the point where its not usable and/or crashes it.

View 1 Replies View Related

Add Datafile On Remote Computer

Sep 19, 2012

i am working on oracle 10g windows & all my disks are full and i want to add a datafile on other computer . how can i do it ?

View 11 Replies View Related

PL/SQL :: Transferring Database From One Computer To Another

Oct 1, 2012

Im doing a project for my college and i need to transfer database. The thing is that i have created tables with databases and linked it to VB using ADODC.

I have done all this in the Computer at my home. So i have done all the project in my computer. I want to show the same project in my college, but i cant do it as the database is stored in my personal computer at home. Is there any ways i could transfer the database from my house to college like storing it in a pendrive. I used sqplus
oracle 9i to create the tables.

View 15 Replies View Related

SQL & PL/SQL :: How To Upload PDF Or JPG Files From Table To Computer

Feb 4, 2012

i have this table structure create table file (id number, media_file blob).how i upload pdf or jpg files from this table to computer for example to C:myfiles

View 3 Replies View Related

Cannot Connect To Database From Remote Computer (ORA-12545)

Jul 19, 2013

I am trying to connect to a database located at my work from at home. I am running into the following issue (see command and error below):

ansichart@ansivm:~/src/perl$ sqlplus aspxdba/********@aspxp2 SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 18 21:15:09 2013 Copyright (c) 1982, 2011, Oracle. 

All rights reserved. ERROR:ORA-12545: Connect failed because target host or object does not exist-- Here is my tnsnames.ora file (I have the service_name censored out for privacy reasons):-

ansichart@ansivm:~/src/perl$ cat $ORACLE_HOME/network/admin/tnsnames.oraaspxp2 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = orarac9-scan)(PORT = 1521))    )  (CONNECT_DATA =(SERVICE_NAME = *****************)(UR=A)    )  )-

I have verified that I can establish a TCP connection to this DB server on the port specified, using the same info from the TNSnames.ora file (see below):-

---ansichart@ansivm:~/src/perl$ nmap -sT -p 1521 orarac9-scan Starting Nmap 5.21 (URL.... ) at 2013-07-18 20:53 CDTNmap scan report for orarac9-scan (10.1.13.115)Host is up (0.0088s latency).PORT     STATE SERVICE1521/tcp open  oracle Nmap done: 1 IP address (1 host up) scanned in 0.09 secondsansichart@ansivm:~/src/perl$--

 I have another terminal opened up to a server at work and I can connect to the DB with sqlplus just fine.  I verified that the record for this database on the tnsnames.ora file is the same as it is at work. In conclusion, I can connect to the Database at work, but I cannot at home, even though I am using the same connection information and verified that port 1521 is accessible on this Database server from at home.  So why can't I establish a DB connection? 

View 6 Replies View Related

Server Administration :: Window Not Starting OracleserviceORCL On Local Computer?

Oct 29, 2013

i m facing an issue about TNS connectivity after some time i start my notebook and then sql butt it can not be login from any side like sql,pl/sql,forms or reports it shows same error ora-12203 tns unable to connect to the destination also my service of oracleserviceORCL can not start it shows an error like 'windows could not start the service on local computer '

View 4 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

SQL & PL/SQL :: Delete OS File In Oracle 8i

May 13, 2010

I am facing a problem while trying to delete an OS file using PL/SQL in Oracle8i v8.1.7.I have tried to use UTL_FILE.fremove but it is not supported in Oracle8i.

how can I delete a file Test.txt from C:Test location?

View 1 Replies View Related

Delete / Update From XL Sheet To Oracle?

May 7, 2008

have one XL sheet Doc that has 2 tabs. One has the list of keywords for deleting the records from Oracle that has the keywords in it. The second one needs the update query. Read the first column in the XL sheet and replace it with the second column value for the records that has the first column value in it.

I never worked in the combination of XL and Oracle.

View 3 Replies View Related

Oracle 10g - Delete 1000 Table?

Dec 21, 2007

I have 1000+ tables in a DISCOVER tablespace in 10g.

I need to drop ALL tables in this area and leave the tblsp intact so that I can IMP a data update from 9i (prod) into 10g (test).

Is there an easy cmd to drop all the tbls, or am I missing someway to do this in DB Console for 10g.

View 3 Replies View Related

SQL & PL/SQL :: Delete Redundant Table In Oracle?

Apr 23, 2012

Is there a SQL query to find out the redundant or unused table in Oracle.

Some tables shows no dependencies to itself or other schemas,but has got valid data in it, deleting it will affect the functionality of the system.

View 3 Replies View Related

Oracle 9i - Delete Data One By One From Particular Table

Oct 28, 2008

I need to create a stored procedure in Oracle 9i which will automatically delete data one by one from a particular table and then by means of same procedure insert record one by one in same table.

View 6 Replies View Related

Backup & Recovery :: Store Backup To Another Computer Containing Same User And Service

Aug 9, 2011

I have created a backup by using rman. Now i want to store this backup to another computer containing same user and service.

View 2 Replies View Related

How To Delete Table Information In SQL Loader Log File Output In Oracle

Jan 19, 2011

I have a SQL Loader Log File Output. I would like to delete Table Information from the output file.Following is my code.

//PATH OPENED AS TEXT BY STREAM READER
System.IO.StreamReader strm = File.OpenText(batchFileName);
//OUTPUT

[Code]....

View 8 Replies View Related

Oracle Triggers - Separate Actions On Insert / Update / Delete?

Jul 26, 2012

For triggers, is it possible to do separate actions on insert , update and delete. For example, if insert is the case, do select; if update is the case, do select from another table and so on?

View 1 Replies View Related

PL/SQL :: Delete Or Empty Single Field Containing BLOB In Oracle Table?

Jul 8, 2012

I have a table in schema with a BLOB field. I store employee's picture in this field. Fields in this table are emp_id (number) emp_name (varchar2) and emp_photo (BLOB). I want to ask if there is a way in pl / sql that i could empty this BLOB field to null or reset this field so that user can change the saved photo graph and save another one.

what i am looking for is something like

alter table employee set emp_photo = empty_blob() or alter table employee set emp_photo = null

View 3 Replies View Related

On Delete Cascade

Mar 27, 2007

We have a bunch of tables with FKs but we do not have the 'on delete cascade' option on these FKs. If I want to delete records in the database do I have to write delete statements for each table starting with the lowest child or is there a cascade option I can use with the delete statement?

View 1 Replies View Related

Way To Bulk Delete

May 16, 2011

what is the error in this procedure.I am getting error where s.msg_id = Tbl_Repo_Salo (i.msg_id));

Create or replace Procedure Proc_Stg_Clear(P_Err_Code OUT NOCOPY number,
P_err_msg OUT NOCOPY varchar2) as
v_count number;
Type Repo_Salo is table of Tbl_Tml_msg_Salo_Stg%ROWTYPE;
Type Repo_Smb is table of Tbl_Tml_msg_SMB_Stg%ROWTYPE;

[code]...

View 9 Replies View Related

SQL & PL/SQL :: Truncate Vs Delete?

Apr 9, 2010

i have one question that why oracle not set high water mark when we delete data from a table and commit it, on the other hand it set in case of truncate.both of these statement release physical structure(in case of delete after commiting)

View 7 Replies View Related

SQL & PL/SQL :: How To Delete Constraint

Apr 26, 2012

i have a problem that i have created a table named PROJECT and structure is like-
CREATE TABLE PROJECT
(
id VARCHAR2(250 BYTE) NOT NULL,
NAME VARCHAR2(250 BYTE) NOT NULL,
COMPID NUMBER NOT NULL,

[code]...

and this table is created in some number of different database then i want to delete the not null constraint of "id" column and there is 3 not null constraint in my table and i didnot gave name at the time of creation, so we cant delete it by its name in the script because there will be different name in another database for the same constraint. i want to make a script to delete the not null constraint because it is the part of my script.

how should i get proper information for deleting the constraint. and i used "user_constraints" but it shows same information for the all three "not null" constraint.

View 2 Replies View Related

SQL & PL/SQL :: How To Delete ORA 00604

Sep 30, 2010

this is my trigger..SQL> create or replace trigger drop_trigger

2 before drop on database
3 declare
4 PRAGMA AUTONOMOUS_TRANSACTION;
5 BEGIN
6 INSERT INTO ddl_log
7 SELECT ora_sysevent,ora_dict_obj_type, ora_dict_obj_owner,
8 ora_dict_obj_name,USER,SYSDATE,to_char(sysdate,'hh24:mi:ss')
9 FROM dual;
10 commit;
11 raise_application_error(-20090,'you can not drop');
12 end;
13 /

DÚclencheur crÚÚ. when a user enter a "drop table" for exemple, the trigger is run but we have this error message

SQL> drop table fg;
drop table fg
*
ERREUR Ó la ligne 1 :
ORA-00604: une erreur s'est produite au niveau SQL rÚcursif 1
ORA-20090: you can not drop
ORA-06512: Ó ligne 9

what can i do to delete the ORA-00604??

View 5 Replies View Related

SQL & PL/SQL :: Delete One Particular Field Value In A Row?

Feb 22, 2010

How to delete one particular field value in a row?

Constraint: There should be no null value or zero instead of deleted value. Other values remain unchanged.

View 14 Replies View Related

SQL & PL/SQL :: Delete An Index

Jun 27, 2010

I have a very huge table. There are many indexes.My focus is on the following indexes:

APT_DEDUCTIBLE A_PT_ORDREGBUS_UNIT
APT_DEDUCTIBLE A_PT_ORDREGMD_CODE
APT_DEDUCTIBLE A_PT_ORDREGPT_CODE

[Code]...

My Question is, since this 3 indexes has two columns "Bus_unit and Md_code", which index can i delete. Will they effect on database performance, if i delete one of them?

View 4 Replies View Related







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