Description:
Oracle database administration/server topics.
|
|
|
SQL Developer Data Pump lizard
|
| |
The new SQL Developer 3.1 is a major improvement in the right direction. Change management pack is now available for free. Apparently, not enough people were buying it, so Oracle decided to give it away. The new Data Pump wizard is also nice but it lacks some basic features. It isn't possible to cancel an existing DP job from the SQL Developer. Bummer! How... more »
|
|
|
Data Modelling and Analysis
|
| |
Hi there ! Is there a comprehensive data modelling tool that can
convert logical data model into physical data model (database) of
your
choice (Oracle / SQL Server / DB2 etc). If yes than can this tool be
relied upon for re-engineering the physical database. If yes then
what
happens to the data that and how is the data managed during the... more »
|
|
|
Data Modelling
|
| |
Hi there ! Is there a comprehensive data modelling tool that can
convert logical data model into physical data model (database) of your
choice (Oracle / SQL Server / DB2 etc). If yes than can this tool be
relied upon for re-engineering the physical database. If yes then what
happens to the data that and how is the data managed during the... more »
|
|
|
Database management strategy
|
| |
Hi there ! I am not a total stranger to database management but at
the same time neither am i a database expert by any means. I got a
serious hypothetical question. Assuming i have a Oracle database that
has been Online for a while and it is slowly running out of physical
hard disk space. How will anyone approach this issue strategically ?... more »
|
|
|
nls settings
|
| |
Hi,
I have a 11.2 database with the following settings:
NLS_CHARACTERSET EE8MSWIN1250
NLS_NCHAR_CHARACTERSET AL16UTF16
Is there any way I could insert all french accented characters into
this database or the nls_characterset forbids that, even if the
nls_nchar_characterset can handle french accents? I created a test... more »
|
|
|
impdp approach
|
| |
oracle 11.2. / on windows
I need to import a select list of tables & packages from a schema on a
source database
I will also need to consider ( perhaps using scripts )constraints/
indexes & stats also
If anyone can give me any helpfull advice before starting & known
pitfalls to avoid I would be gratefull... more »
|
|
|
Vanishing table in 11.2.0.3
|
| |
Query is extremely simple and the result is expected:
select ename,job,mgr,deptno,sal from emp
where deptno in (select deptno from dept)
/
ENAME JOB MGR DEPTNO SAL
---------- --------- ---------- ---------- ----------
SMITH CLERK 7902 20 800
ALLEN SALESMAN 7698 30 1600... more »
|
|
|
EXAMPLES OF PROPHET’S MERCY UPON NON MUSLIMS !!!!!!!!!!!!!!!!
|
| |
EXAMPLES OF PROPHET’S MERCY UPON NON MUSLIMS
Ex. No. (1)
It was narrated that ‘Aisha, May Allah be pleased with her, said to
the Prophet, Peace be upon him: "Have you ever come across a day
harder than the day ofUhod (one of the battles with the polytheists,
in which Muslims were defeated failing to comply with the Prophet's... more »
|
|
|
New Metastink
|
| |
I don't see my SR history and I don't see my saved patch searches. I know that everything will work in a month or two, but this @#$%! annoying.
-- [link]
|
|
|
