Client Tools :: How To Replicate A Package In One Database To Other
Sep 4, 2013
I have a package called getEmpData in database orcl. I want to move/creat the same package on other database called ora. I want to do/simplyfy this work through PLSQL DEVELOPER.
View 3 Replies
ADVERTISEMENT
Nov 11, 2010
I want to add my function to the existing package.
View 8 Replies
View Related
Mar 16, 2013
I have made a package and define a variable in it as:
CREATE OR REPLACE package Scott.My_Pac as
CNT_UPD_USR Varchar2(20)
END My_Pac;
When I used the following in Toad it works fine but when I use the same in 10g form it gives the error "Cannot directly access remote package variable or cursor".
Begin
Scott.My_Pac.CNT_UPD_USR := 'Ali';
DBMS_OUTPUT.PUT_LINE(Scott.My_Pac.CNT_UPD_USR);
End;
View 6 Replies
View Related
Jan 27, 2011
1- I do not have access to TOAD for Oracle yet
2- I can connect to SQLPLUS: Release 9.2.0.1.0
3- We have many stored procedures in packages that are available from the TOAD for Oracle interface
4- I need to be able to see the specs/body of some packages containing some procedures.
5- I am connected to the appropriate DataBase1 (for example), but from here what to do from SQLPLUS command prompt ?
For example: SchemaName1.PackageName1.ProcedureName1
View 39 Replies
View Related
Jan 13, 2011
can we use oracle client version to create a database in that server.
View 3 Replies
View Related
Dec 11, 2012
I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.
So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following
export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1
when I try
# sqlplus
username :xxxxxxx
password : xxxxxxx
ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.
View 1 Replies
View Related
Feb 17, 2012
we have a production database 'X'. Now i have created a test database 'T' and did'nt configured another listener to it! The issue is when i cam connecting to oracle through sqlplus i am directly connecting to Test database 'T' but not the production database 'X'----ofcourse i can login to production DB afterwards. but initially i want to access the production database 'X'.
View 15 Replies
View Related
Jun 15, 2011
I want to move a oracle job from one database to another database. i tried to open the job from toad by pressing f4 on it in editor , im getting message like...
"unsupported type for describe popups (Without DB admin module)
View 2 Replies
View Related
Oct 10, 2011
I am connected to an oracle database on campus thru my laptop. The interface i am using is oracle sql developer. We are practicing entering SQL commands. The connection name is DBA120. So, the name of the database is DBA120, correct? Also, I must review the respective ERD (i.e., to know the table relationships) in order to determine the proper sql commands, correct?
Well, in this database connection (DBA120), there are several tables that actually pertain to three different databases, ACCOUNTING, BOOK, and DJ. (I have the respective ERDs.)
I want to be able to save a database to file so I can run it on another computer. How do I save each of the three databases to a file or can't I? Or must I save the DBA120 database? how do i do that? do i save it(them) as sql files?
View 2 Replies
View Related
Mar 30, 2012
If i create database on server(remote desktop connection) and try to some R&D like shutdown or startup command it will effect my other database or not.
View 1 Replies
View Related
Oct 4, 2013
I am getting error in my database....
SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
I tried shutdown and startup
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 4 22:31:06 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> shutdown;
ORA-01507: database not mounted
[code]....
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>
View 1 Replies
View Related
Mar 23, 2007
I want to replicate my Oracle XE database in Oracle 10G. Is their a 'simple' way to do that? I know that XE does not have server backup.
View 2 Replies
View Related
Jun 24, 2013
How I can connect database on unix OS and windows what is the deference.
View 7 Replies
View Related
Jan 21, 2010
We are using oracle10g database. Every time, we need to run the sql query and find answers for them. We are getting lot of request every day. I wanted to develop interface and i want ops team use the interface to pull the data.
Here are my thoughts...
1. using oracle APEX to develop interface.
2. Use the excel to write macro and get the answers for user request.
3. I can write a PLSQL to run the batch job and extract the data into excel and give it to ops team.
View 1 Replies
View Related
Jun 5, 2013
I heard .MDD file is Database Designer for MYSQL(i don't knw exactly).how to create it..
View 1 Replies
View Related
Dec 4, 2007
I have a table MYTABLE in database mydb1 duplicated via materialized view and materialized view log and refresh_snapshot commands to a MYTABLE on mydb2 database.
I like to duplicate this table MYTABLE to a third database mydb2, using the same method (materialized view and refresh_snapshot command).
Is it possible ? What's hapend to the materialized view log where I launch a refresh_snapshots on mydb2 ? How is this materialized view log truncated ?
View 5 Replies
View Related
Jan 31, 2013
I Have one oracle user ABC which is having 10 Tables.
Now i want to create replica of this user XyZ which can access only 5 tables from . This user having All access.
Example :
Any DML changes made in XYZ these changes should be reflected in ABC user. and vice a versa.
How can i achive this in ORACLE DB.
View 10 Replies
View Related
Jun 13, 2013
how to migrate sql server database to oracle database?
View 2 Replies
View Related
Jul 7, 2010
We plan to migrate the databases to Oracle 10gR2 from Oracle 9i. know whether Toad 8.5 works fine with Oracle 10gR2 or not?
View 4 Replies
View Related
Mar 27, 2013
I installed Oracle 11g client and set the ORACLE_HOME and tns_admin env variables.I installed the pl/sql developer, but unfortunately after installing , i am unable to see any database details in the drop-down list of pl/sql developer.
View 4 Replies
View Related
Jun 27, 2013
i have my oracle 10g database on my windows 7 and i install sql server 2005 on my windows server 2003 .now i want to sync my oracle 10g database with my sql 2005 means whenever i make any changes in my oracle table its automatically effect in my sql server also.
View 1 Replies
View Related
Dec 8, 2011
when i am trying to connect to the database using sqldeveloper i am not able to connect to database. its giving me an error "Unsupported Oracle database version" but with plsql developer I am able to connecting.
View 8 Replies
View Related
Apr 23, 2012
there is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.
View 9 Replies
View Related
Apr 17, 2013
My primary objective was to compare objects in schemas in two different databases and find out the differences, Execute DDL's in the database where objects are missing and syn schemas in two different databases. So I need to compare schemas in databases. make a comparison of database objects existing in schemas in two different databases. I'd like to see if I can get a list of pro and cons between Toad and SQL Developer for comparing schemas pros and cons. navigation in SQL Developer to compare schemas.
Connect to Source
Connect to Target
Compare schemas with different object types
Find out differences
Generate DDL's for the missing objects or for the objects in difference report
Run them in missing instace(Source/Target)
Make sure both are in sync.
View 2 Replies
View Related
Jan 16, 2011
want to load data from an excel file to a database table in Oracle. I am using Oracle 11 and the excel file has 3 columns as compared to 5 columns in the destination table. I want to generate sequential nos also for the table.
View 7 Replies
View Related
Mar 21, 2012
i have oel installed on my parallel Virtual machine.
i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.
my os is windows7 32 bit.
View 13 Replies
View Related
Feb 17, 2010
I am trying to connect to database using ERWIN Data Modeler (7.1.0) but the following error occurs.
ORA-01041:internal error. hostdef extension doesn't exist.
The connection to database through other tools (e.g PL/SQL Developer etc) are successfully established.
View 3 Replies
View Related
Apr 11, 2007
I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?
View 12 Replies
View Related
Aug 21, 2012
I am using SQLTools 1.5 for writing Oracle SQL scripts.
I have to import data from excel file to oracle database. How can I do it?
Also how can I export data from Oracle database to Excel file?
View 2 Replies
View Related
Oct 28, 2013
While trying to logging to database through pl/sql developer, getting error as "ORA-01031: insufficient privileges".But am able to logging by system.
As per the instruction by the below link, checked the privileges of ord_dba. All are correct. Now, i am in puzzle to rectify the error.
[URL]
View 3 Replies
View Related