my database consists of different tables, i am trying to design a form as follow:
1. list item (this list item will be populated with player email addresses from player table)
player(p_i...
I was creating a password for the listener and when I set the password it
(i.e. set password lsn1). I got the following output:
The command completed successfully
However, when I issued...
This should be an easy question. I know I'm just missing something here.
Background:
I've got 2 servers. Each with Oracle 9i on them. One called PROD the other called BCDS. I've made a du...
I type the following to export:
exp owner=tems_adm file=/tmp/tems_adm_orig.dmp indexes=y constraints=y rows=n log=/tmp/tems_adm_orig.log
But at the end of the export I get these errors:...
Please explain in detail in terms of storage , performance. Thank you!
my sequence is just cycling two numbers?
SEQUENCE_OWNER SEQUENCE_NAME MIN_VAL MAX_VAL INCRE_BY C O CACHE_SIZE LAST_NUMBER
----------------- --------------------- ------- ----...
Hello,
I'm trying to insert a word doc into the database as a long raw. I'm not using Blob's because I can't return them correctly for the users with the application that we use.
I was ...
I have been tried to connect my DB (SID=WDH) by command: sqlplus system/system@dwh
after that, it orccured error so I COULDN'T resovle problem. System has a message "ORA-12523: TN...
Hi All,
I need to build a stored procedure to insert data into different tables of a database.
Here each table is different from other in the concept of number of columns and data types....
I have migrated my database from Oracle 8.0.5 to Oracle 10g, version 10.0.1.0.3 through import-export utility. During migration, one difference I made was to change the NLS_LANG to UTF8 from A...
I am getting below error on unix even though java is install there. What I am trying is to create a store procedure.
create or replace and compile java source named javatimeconversion as
*
...
Hello,
Very simple question - is it possible to use Oracle exp from remote machine. E.g. there is an Oracle database server and I need to connect to it from my PC and export data.
I tried...
Hi,
OS : Solaris 9
Oracle 9.2.0.5
My objective is to move an index from one tablespace to another.
alter index <index name> rebuild tablespace <tablespace name>
It fails with ...
I have installed Oracle 10 G 10.1.0 on a computer where Oracle 9i (9.2) is already installet. I do not use Oracle 10G so much, only for testing.
Now I find that I cannot access Ora10.
Wh...
Dear Experts,
I have been Oracle8i installed successful. First time, when Oracle has been installed so the listener run and i had create new DB . But It immediate stop after DB has been creat...
I have a full export for my development databases and one of the development databases export is failing.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the ...
I enabled archiving when I created a database. I verified this configuration by typing archive log list at the sql prompt.
------------------
SQL> archive log list;
Database log mode ...
Hello,
i was trying to insert new values into a table which has spatial data .i encountered the following problem ..
could anyone help me out with the problem.
SQL> insert...
I know how to startup Oracle database(connect sys as sysdba with sqlplus; startup; ) but I can do this only manually. What I want is to put this into a script that runs when the server boots. ...
hi all
i wrote one stored procedure in oracle, i need to call the stored procedure for every 5min. How can i create the job for this in oracle8.0.
I am using TOAD4.0, in toad they g...
Hi All:
I have been trying to get Oracle 10g instant client running on my computer for hours.
The platform is Windows Server2003,it is running within a PC Client and the Oracle installat...
We have oracle server on UNIX machine and oracle client on Windows machine.
UNIX : Oracle server : 9i
Windows : Oracle client : 9i
When we insert a record with special characters ( germ...
Hi Experts,
I want to pass table name as parameter to a PL/SQL Stored procedure which deletes all the rows in that table.
Is it possible to do so?
Or else do we need to go for dynami...
Hi I'm been using M$ sql server forever and, now I've moved on to oracle and I can't seem to get this subquery stuff right. Can someone please help. Here is my terrible wrong query.
Updat...
Does anyone know how to set a user variable to a value in a bind variable within SQLPlus?
For example, if I set up a bind variable like so:
variable today_date char(8);
Then, I s...