Oracle
This is the archive for Oracle.
Dive into the archives.
- Oracle: Could not create another database? Create another data source.
I needed to set-up another data source using the same database server
—–
So using the SQL Plus, i created a user and granted privileges for it.
Creating User
SQL> create user username identified by password default tablespace user_tablespace temporary tablespace temp_tablespace;
e.g.
SQL> create user wpsdbusr identified by password default tablespace users temporary tablespace temp;Granting Privileges
[…]
- Transposing Records into One Field
As they say in Exist, There’s always a better way.
What I Did…
performed a loop for each record in my collection to retrieve another collection using a particular Id in the record
and placing the retrieved collection to be part of the record.
The Effect…
my screen populates very slow
The Solution…
from backend, transpose those collection being retrieved […]
- Debugging in Eclipse, calling shell scripts
Background:
i’m using Ubuntu, my Eclipse was installed via apt-get
i have Oracle installed under ‘oracle’ profile
i run and debug my program through Eclipse
Issue:
attempt to run sqlldr which is called from the webapp results to an error/sqlldr exit code 3.
Solution:
run the webapp externally, don’t use Eclipse when running the webapp(since it was installed via apt-get and uses […]
- Installing Oracle 10g in Ubuntu 7.10 (Gutsy Gibbon)
This doc isn’t yet perfect, but it would help.
1. Requirements
Your linux swap is set to 2GB
You have the Oracle 10g RC2 installer for Linux
2. Setting Ubuntu
2.1 Install required libraries
Open the Synaptic Package Manager (click System –> Administration)
Click on Settings –> Repositories
Click all the checkbox(main, universe, restricted, […]
- Oracle Hibernate URL Connection String
Bout: jdbc:oracle:thin:@localhost:1521/orcl vs jdbc:oracle:thin://localhost:1521/orcl
Story:
1. Checked out the project
2. set parameters for the DB connection
3. built it and attempted to run it.
Problem: The app wouldn’t run.
Attempts to solve:Checked parameters of database-c3p0.properties
* system.connection.username=system (able to use this in the sqlplus)
* system.connection.password=password (this was the password assigned during […]
- Dumping data to Oracle 10g via command line
Assuming you have already created the DB user, see http://blogs.exist.com/jcutaran/2008/02/18/creating-a-user-in-oracle-10g-through-command-line/
1. Log into a command console with the oracle user
> su - oracle
2. execute the command template below
imp userid= fromuser= toUser= file= log= compile=y commit=y
example:
> imp userid=system/password fromuser=NPN6 toUser=NPN6 file=~/version1.dmp log=~/imp.log compile=y commit=y
some notes:
userid - refers to […]
- Creating a user in Oracle 10g through command line
Assuming Oracle is installed and running…
1. Log into a command console with the oracle user.
> su - oracle
2. Creat a file and place the text below.
drop user npn6 cascade;
create user npn6 identified by npn6;
grant resource, connect, create view to npn6;
commit;
3. log into sqlplus to run the file you created
>sqlplus / […]
