Oracle Database Express Edition (Oracle Database XE) is an entry-level, small-footprint database, free to develop, deploy, and distribute; fast to download; and simple to administer.
0
votes
2answers
47 views
Oracle 10XE: Stop schemas seeing the all_users table?
I've got an Oracle 10g XE Database that I want clients to be able to view remotely via SQL*PLUS or SQL Developer. Each schema has a name which includes the name of the client, so anyone looking at the ...
1
vote
1answer
25 views
Oracle Express intermittently stops responding, requiring a OS reboot to fix
I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out.
There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 ...
1
vote
4answers
125 views
Copying my Oracle 10g Express database to another PC
I have Oracle 10g Express. How can I make a copy of my database and application?
I don't want to make a back up, I want to move my DB and application to another PC.
0
votes
1answer
172 views
Set encoding from within SQL*Plus
I have a large set of files with SQL commands that I run with a SQL*Plus script that uses the @@ operator. I run the script on third-party computers (or even send it by e-mail) so I'd like to make it ...
0
votes
0answers
808 views
Oracle XE TNS Listener fails to start
I freshly installed Oracle XE 11.2.0.2.0 and found out that the TNS Listener service fails to start. At first I tried to start the Windows service by hand. After the failure this is the entry in the ...
1
vote
1answer
1k views
Difference between database dump (export) and database backup?
What is the drawback using only EXP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference between ...
2
votes
1answer
186 views
Which backup files are needed for a successful restore?
Considering the built-in 'Backup Database' script (backup.bat) that comes with a new installation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
2
votes
1answer
2k views
Installing Oracle 11g XE on Ubuntu 12.04
I have spent the last 6 hours trying to install Oracle 11g on Ubuntu. Obviously, I'm not the only one who has struggled with this, as there is a lot of (often misleading) "documentation" online on how ...
1
vote
2answers
298 views
Trigger to automatically add values to a table in Oracle
I am new to Oracle.
I am looking for a trigger which helps to automatically insert values into a table when data is entered into another table in the same database.
I have tried a lot and didn't ...
-1
votes
1answer
317 views
Oracle XE: Transfer Database from Linux to Windows
our professor gave us a linux VM with a Oracle XE 11g Database.
I want to transfer this Database to my Windows installation because I dont't want to boot up the VM for every exercise.
Everything ...
0
votes
1answer
969 views
How do I discover the Oracle Express workspace name?
Is there a way to discover the WORKSPACE name if I've forgotten it?
I cannot login to the APEX admin console since I've forgotten what the workspace name was.
I do know the SYSTEM user password.
...
1
vote
0answers
112 views
Populate database column with drop-down menu item
I'm quite new to Apex and Oracle in general, but I would like to know how to populate a database column with the data from
the drop-down list
Currently I'm not getting further than simply creating ...
2
votes
1answer
775 views
ORA-12899: importing a .dmp file + character set conversion
I'm working on a django project on Ubuntu 10.04 with Oracle Database Server , so I've installed: Oracle Database 10g xe universal Rel.10.2.0.1.0 cx_Oracle-5.0.4-10g-unicode-py26-1.x86_64
When I ...
0
votes
1answer
404 views
Cannot Login after configure oracle-xe [closed]
I already success install oracle-xe on my ubuntu 10-04, tried to configure the port and password sudo /etc/init.d/oracle-xe configure, and then restart my computer and go to http://127.0.0.1:8080/apex ...
2
votes
1answer
687 views
SQL on Mac OS X
I'm looking for something like "Oracle database express" to be used on a mac.
I hope this question won't offend anyone though.
I'm absolute beginner on sql.
Your suggestions are most welcome.
0
votes
1answer
408 views
Error during the installation of oracle 11gxe
When I tried to install Oracle 11g XE into my machine (Windows XP media center edition, version 2002 SP3) I'm getting an error as
0x80040702 Description: Failed to load DLL:chkportDll2
I've ...
1
vote
1answer
425 views
Oracle XE 11.2 Export / Import Charset
I created a database in oracle XE 11.2 that uses charset AL32UTF8 that I now want to export.
When I perform the export, the resulting data appears in WE8MSWIN1252 character set and AL16UTF16 NCHAR ...
5
votes
3answers
4k views
Cannot drop nonexistent constraint and cannot create it either
While testing some migration scripts with a copy of production data (scripts run fine with development data) I found a curious situation. A CONSTRAINT has changed so I'm issuing DROP + ADD commands:
...
