Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

1,167 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
-1
votes
1answer
1k views

Inserting dates before year 1950 in Oracle

How can I insert date which is before 1950? update up_sif.tb_person set dateB =to_date('18.10.1949','DD.MM.YYYY') where ID = '123345'; It keeps update with date 18.19.2049. Any ideas?
-1
votes
1answer
242 views

I want to change ORACLE level#2 to log archiving mode instead of the current mode

I want to make that change to the archive log mode to use the redo log files to use it to make replication to database to another server. This is easy and possible when the server is single not multi-...
-1
votes
1answer
710 views

Oracle database - how to switch instance

I'm totaly new in oracle, so sorry for my probably stupid question... I have two instances on oracle server, when I'm connecting to the server via sqlplus in default opens connection to instance X but ...
-1
votes
2answers
1k views

How can I estimate the size of a new table?

We have tables with a lot of data (50M new rows each month, just in one table). Now I want to know what would be the impact of adding a new column to those tables, or creating a new table. Something ...
-1
votes
2answers
19k views

How to resolve parameter file error

I log on to my database but giving me this error message ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0.2/db_1/dbs/...
-1
votes
2answers
510 views

To know list of users having access to Views

Please help me to find out the list of users who are having access to particular user defined views in Oracle.?
-1
votes
2answers
897 views

Why Toad turned my LEFT OUTER JOIN into a RIGHT OUTER JOIN

I finally figured out the answer but it might be useful for someone looking up the same question so here is the whole write up to hopefully save you the frustration. Problem I had: Toad's query ...
-1
votes
2answers
6k views

How to find out to which roles have grants on certain tables?

I have 2 tables and I want to know what object (table) grants are assigned to a role. Is there a way to find it out?
-2
votes
1answer
62 views

Fetch 2 different columns same data in 2 different rows

I have an issue and got stuck very badly. I have a table product which has 5 columns: col1 col2 col3 col4 col5 There are a few records where the same value is repeated in different columns and in ...
-2
votes
1answer
88 views

Syntax issue with Procedures in 11g

I have a problem with running below procedure in oracle 11g because of the JSON value feature not available in 11g. Can you please help in correcting the procedure. create or replace PROCEDURE ...
-2
votes
1answer
98 views

Post DB users into replica users the Synonyms still point to Source DB users

I have exported users HR,Fin AND imported into new users HR1,FIN1 in the same DB. The expdb is used for this purpose.The synonyms still point to the source users (HR,FIN) Example : Synonym def in ...
-2
votes
2answers
350 views

Oracle SQL Query

Query the two cities in STATION (Table) with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or ...
-2
votes
1answer
5k views

LOAD DATA statement not working in Oracle SQL Developer

When I run the statement: LOAD DATA LOCAL INFILE 'C:/path/date.txt' INTO TABLE dimdate FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (date_id, yyyymmdd, fulldate, weekofyear, month, quarter, ...
-2
votes
1answer
22 views

Oracle database control files issues and problems?

I was given an assignment which asks me to answer the following questions: What problems does the dba face with control files? How does the dba analyze and get to know these problems? What are the ...
-2
votes
2answers
779 views

Remove oracle home base in windows

How to manually remove multiple the oracle home base in windows inorder to start with a fresh install of oracle server. I had unsuccessful attempts in deleting it using the Universal Installer as it ...
-2
votes
2answers
47 views

How do i use an IF statement in my procedure?

This is my procedure CREATE OR REPLACE PROCEDURE INSERT_ALL AS BEGIN INSERT_INTO_P_ENZYME; INSERT_INTO_P_EXPR_SYSTEM; INSERT_INTO_P_BUFFER_SYSTEM; INSERT_INTO_0_CONSTRUCT; INSERT_INTO_1_PRODUCED; ...
-3
votes
2answers
361 views

Need a shell script that can run a oracle query and produce output in .csv format

Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...

1
20 21 22 23
24