SQL & PL/SQL :: Test Parameter?
Jan 12, 2012
I need to test a parameter in a script that must adhere to what is currently in the database.For example, when a user enters the value when prompted from this script, ("Enter the schema copy desired: " ) the value must be of the current values in the db:, it would be something like this:
Values currently in DB: copyofschema201110 (the 2011 is the year, and 10 would be the month of oct).
copyofschema201109
copyofschema201108
So, if the user enters the value 'abc' (an incorrect value), then I would like the script to stop the user, and kick back a message, say from dbms_output.put_line, and force the user not to go forward, but re-enter a correct value.
View 13 Replies
ADVERTISEMENT
Feb 7, 2013
I have below mentioned records in mount so whenever i select any mount it should now show the the last row of that mount i.e. test no-3 any records of mount which will not show last row of test number
mount day org1 test_No org2 org3 org4
299.00 1 0 1 1 0 7186
299.00 1 0 2 1 0 7186
299.00 0 3 3 0 7186
[code]...
but i want test_no should be in asceding order
View 3 Replies
View Related
May 29, 2013
I suspect it uses TABLE, CAST and/or MULTISET functions in a query .. but reading the docs on those, I can't seem to piece together how to do it.
When I piece together a sample/test query, I usually do something like this:
WITH data AS
( SELECT 123 id, 'abc' col1 FROM dual UNION ALL
SELECT 234, 'def' FROM dual UNION ALL
SELECT 345, 'xyz' FROM dual
)
SELECT *
FROM data -- usually more complex query here
However, I saw somebody do this without using the UNION ALL .. they did something with TABLE ( ... ) ? it seemed "simpler" than the UNION ALL method I've used previously
View 10 Replies
View Related
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
Sep 15, 2010
I have a unix script that will check if the database is up and running. I need a similar script but this time in windows batch file.
this is the snippet of the code from the unix script:
#! /bin/sh
sqlplus -s /nolog > /dev/null 2>&1 <<EOF
whenever sqlerror exit failure
[Code].....
View 2 Replies
View Related
Feb 21, 2012
CREATE TABLE TEST
(
NAME VARCHAR2(1000 BYTE),
ID NUMBER
)
[Code]...
I want the update the TEST table with TEST1 based on id column,i tried as like.it's not working..
UPDATE test t1
SET t1.ID = ( select ID from test1 t2
where t1.name = t2.email and rownum=1 )
View 13 Replies
View Related
Dec 30, 2010
table
CREATE TABLE "TEST"
("CONTRACT_REF_NO" VARCHAR2(20 BYTE) primary key,
"CHG_GL" VARCHAR2(9 BYTE),
"CHG_GL_1" VARCHAR2(9 BYTE),
"CHG_GL_2" VARCHAR2(9 BYTE),
[code]...
10 rows selected.
create or replace view test_view
as
select 1 id,CONTRACT_REF_NO,chg_gl
from test
union all
[code]...
11 rows selected.
I have done only for one id.
so the problem is the front end is showing this test_view that people will modify.but they have to actually modify the table ,so I can think of an instead of trigger(instead of insert and instead of update ones).
View 16 Replies
View Related
Sep 6, 2011
How to test row movement? I want to a row data reside in two different blocks. how to do the test?
View 13 Replies
View Related
Sep 16, 2012
How can i test my Procedure /Function/Package, i mean how to unit & integration test my Procedure /Function/Package. Is there any tool available in the market, or we have to test in manually .
View 6 Replies
View Related
Aug 29, 2012
recently i have tried to upgrrade from oracle 11.2.0.2 to 11.2.0.3 in a test environment (virtual machine).
there i have mentioned the SID as ORCL, but when we took the same snapshot to other machine (VM). iam unable to connect to the VM, unless i gave the local net service configuration as ORCL but it is unable to connect. but when i ran the query "select * from GLOBAL_NAME" output was ORCL. domain. com again i have configured in LNSC as ORCL.DOMAIN.COM it is working.
but i have given the sid as ORCL..
View 5 Replies
View Related
Feb 15, 2012
We have a RAC in a test environment.It's 2 nodes connecting to an IBM DS3512. The DS3512 has one pool of 8 hard disks (RAID10) which has been then sliced into logical drives:
2 x 1GB
then
2 * 400GB
I have been tasked with changing the current configuration as follow:
2 pools of 4HDs in a RAID10 configuration
Then from the first pool:
2 * 1GB
1 * 398GB
from 2nd pool:
1 * 400GB
What I intend to do:
1) shutdown
SQL> shutdown immediate;
./srvctl crs stop
2) backup
dd if=votingdisk of=voting_disk_backup
I already got backups of OCR in $CRS_HOME/cdata/crs/
3) Perform changes on SAN
4) recreate ocfs2 partitions
5) mount the disks to their folder.
6) recovery
recover voting from backup
recover ocr from backup
7) Turn service on again
./srvctl crs start
SQL> startup;
Would this scenario work. There can be some glitches like the disk names changing after the reconfiguration but I only need to modify fstab for that.
View 3 Replies
View Related
Sep 13, 2013
i've perform a stress test of a database in 2 configuration :
1) Single instance 11.2 with 8gb Sga e 4gb Pga on Linux, 6core with instance caging =4, resource_manager=defaut_plan
2) 2 Nodes Rac 11.2 with 8gb Sga e 4gb Pga in both nodes on Linux, 32core with instance caging =4, resource_manager=defaut_plan.
I've used Swingbench and the transaction per minute are equal, Avg transaction per s in rac are Greater then single instance (4ms vs 40ms).I know that rac is not for high performance.My question is: is rac config best than single instance and if yes what is the %?
View 0 Replies
View Related
Aug 29, 2012
I want to create a database trigger which will test the database link, if it is ok then it will use dblink and do its work.
If it fails then it will send the data into its own server logfile.
I Wrote:
CREATE OR REPLACE TRIGGER PERMIT.TESTTRG
AFTER INSERT OR UPDATE
ON PERMIT.TR_LP_M_H_COMPANY_25072012
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
Declare
l number; nIgn PLS_INTEGER; nRows PLS_INTEGER := 0;
[code]....
When I execute it it is giving error:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/11 PLS-00201: identifier 'EXEC_SQL.CONNTYPE' must be declared
4/11 PL/SQL: Item ignored
8/2 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
[code]....
View 4 Replies
View Related
Nov 15, 2011
I would like to know that how can i automate the export from production to test server. I need direction to create process to import data from production (server A) to test server (server B).
View 6 Replies
View Related
Dec 18, 2010
I want to test custom Jar files with Forms 6i from my desktop, but I cannot get the Run Form->Web to work. Is it possible for the run time to load the just jars for PJC when you do Run Form -> Client/Server? So far, when I have done this, it does not execute any PJC.
View 2 Replies
View Related
Nov 1, 2013
I am creating a script to populate a test table. But I cannot auto increment the DATE column,
declare v_idnumber := 1 ; v_datedate; begin while(v_id < 100 ) loop v_date:= TO_DATE( '07-23-2012', 'MM-DD-YYYY'); INSERTINTO datetest (ID,startdate) values( v_id,v_date); v_date:= v_date +1 ; v_id:= v_id +1 ; endcommit;end;loop;
View 0 Replies
View Related
Jun 18, 2012
I have a table with full path and name of a document or a URL.
Users can now open one of these documents by klicking on a link.
P:Document est.doc
or
URL....
Some times this document no longer exisits. How do I make sure the user gets a correct error message? URL....How do I make sure the user gets a correct error message?
View 4 Replies
View Related
Jun 19, 2013
I am running the login page on the server with the below URL .
[URL]...
However I am getting the below error .
Frm- 40010 Cannot read form test.fmx
View 1 Replies
View Related
Oct 4, 2012
Oracle 11gR2
I have on table 'Test' in database and I want to know currently which sql statements are being fired on table 'Test' ?
View 8 Replies
View Related
Feb 1, 2011
I have to migrate the current production database to test 10.2.0.4 on windows. Any non-export way to upgrade 9i to 10 g?
i have following steps
1) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
2) shutdown oracle 9i database on server A
3) copy database file, controlfile, redolog, and other files to new server B
4) alter the controlfile backup with new location of bdump, udump, and log file and data file locations
5) user oradim ORADIM -NEW -SID SID [-INTPWD PASSWORD ]-MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
6) start dabase in upgrade mode
7) run catpat.sql and util102.sql
8) take backup
9) open database for users
View 3 Replies
View Related
Jan 26, 2012
I want to automate the import from production to test.
1) export the production schema
2) import in to test server?
How can i automate that currently i am doing it manually as follow:
1) expdb the production schema
2) kill all connection on the test server to test schema
3) drop test user cascade;
4) recreate user;
5) impdb the production schema to test:
but i want it to automated or scheduled so i don't; have to log in every night!!
View 5 Replies
View Related
Jul 22, 2013
I am looking for different cheap storage options to build test RAC setup for DB on Linux@Dell PowerEdge T100 .
View 1 Replies
View Related
Feb 25, 2013
We just upgraded one of our databases to 11g on a new server. The 3rd party application that accesses the db is 32 bit. The software needs to be running on the db server in order for some transactions to occur. Since the oracle client on the db server is 64bit do we need to install a 32 bit client as well. As of right now we are getting an error in the software when trying to connect to the db that says "Test failed. provider cannot be found. it may not be properly installed." This is a live production server so uninstalling and reinstalling oracle is not really an option at this time (unless absolutely necessary). How will installing a 32 bit oracle client effect everything (if that is the route we need to take).
View 3 Replies
View Related
Feb 19, 2013
I want to test full backup (hot backup using RMAN) of my DB (11.2 SE) on another server (I didn't install DB on yet).
View 6 Replies
View Related
Feb 8, 2013
I am having performance issues on a query in a production environment that I cannot replicate in our test environment. Our test environment is an import of production. Version information is:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - ProductionWhen I run the query in test, I get the following results using TKPROF
[code]....
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWSThis performance problem started a few weeks ago and the problem seems to be in the high number of consistent reads during fetch. The DBA tried restarting the instance and gathering fresh stats on the tables but that has not made a difference. Now he wants to export the tables, drop the schema and re-import.
View 8 Replies
View Related
Aug 29, 2012
I created an report and made it accessible as Restfull server. When I checked the url, I got an XML back. So the service is working.
As test I wanted to create a webservice reference to that same page, but receive ORA-06502 PL/SQL: numeric or value error: hex to raw conversion error whenever I test the service. I tried all kind of options.
Settings:
URL ...........
HTTP MEthod : GET
Parameters
app
page
reportid
(and even parmvalues, lang, output)
outputformat : XML
When I test this service I receive above error. I use Apex 4.1
View 0 Replies
View Related
Jan 21, 2013
outlining 'key' differences between databases / configuration / hardware that can potentially make a difference to what results you get when running sql / pl/sql - I am trying to find a check list to use against PROD / DEV / TEST environments.
View 2 Replies
View Related
Jan 12, 2011
1)Want to perform an Export from a Production Schema and Import the results into Test Schema. BUT, do not want to export ALL objects from Production (only a subset of tables). Is this possible?doco on how to do this? (rather than a complete Export and then a complete Import).
2)I have 2 test instances of Oracle on the same development server, UNIT and SIT. Am using Oracle SQL Developer tool.
While in the UNIT instance, is there a way to select data from the SIT instance? An example of syntax to use?
3) Can tables in the UNIT instance be compared to tables in the SIT instance, through any existing Oracle utilities
View 2 Replies
View Related
Jul 21, 2012
I still have a legacy apps built using Forms 6i and Reports 6i running against Oracle 10g database on a Windows XP client and Windows 2008 server.It seems working well on Windows 7 client (32-bit only), but I think that it needs to test this apps.
View 11 Replies
View Related
Oct 31, 2012
Steps to Refresh test Oracle 9i schema from production schema on a Windows platform..
View 3 Replies
View Related
