0
votes
0answers
28 views

increased tablespace but dba_tablespace_usage_metrics order shows same

Although I appear to have solved the problem of the tablespace being full I am perplexed that after altering the the datafile size that the tablespace size has remained the same. What is it that I ...
-1
votes
1answer
42 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
0
votes
2answers
321 views

Installing scott schema for oracle 11g express

I want to install scott schema, a sample database in oracle. But in express edition, I can't find out it. Please help me install it on Oracle 11g express. I'm a newbie, pls help me
1
vote
1answer
160 views

Recover corrupted blocks in Oracle 10g XE

I am using Oracle 10g XE. I've noticed corrupted block error in datafile 1 in alert log. As I've found Oracle XE doesn't support Block Media Recovery(needs to be Enterprise Edition). So I did the ...
0
votes
1answer
225 views

oracle XE on windows XP stopped working

I know this will be greeted with derision, but yes I'm running Oracle XE on Windows XP. Long story involving office policies and VMs. Actually it's been working fine for a couple of years, but today ...
1
vote
2answers
81 views

A Separate Oracle Database at work

I recently started working at a company (Junior Web Developer) and so far loving it. The company's all and only database is one giant Oracle database that takes care of all their data persistence ...
1
vote
1answer
2k views

Mounting a database from database files copied from a previous installation

I recently had on Oracle 11g Express database crash. I have copied the .dbf files from C:\oraclexe\app\oracle\oradata\XE to another folder and reinstalled Oracle 11g Express. The files are: ...
1
vote
0answers
281 views

SQLPlus times out when connecting to an Oracle XE database on another PC

I'm having the strangest issue. I have a very basic (I think) setup of an Oracle 11G database on one Hyper-V VM, and the Oracle 11G client on another VM. Although I'm able to access the database on ...
0
votes
2answers
290 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
175 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
2k 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
4k 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
4k 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 ...
2
votes
1answer
4k 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
3k 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 ...
0
votes
2answers
5k 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. ...
2
votes
1answer
1k 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
680 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
858 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 ...
8
votes
3answers
8k 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: ...