I got an error SQL1042C. An unexpected system error
occurred.
Explanation:
A system error occurred. One possible reason for this error
is that the database manager is not installed correctly or
the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very
common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
The tables and views would not be opened. What is the way
to open the dataase?
pls help me
I want to export only structure of the table from oracle
database. In that table to used the some partition.
To export the table in general way then compilation error
was occured i.e-EXP-00003: no storage definition found for
segment(11, 2771). Please tell me the correct export command
parameter to export the partitioned table.
Thanks in Advance..........
CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva
. I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman.
My catalog db is called rman. How would you run this shell
script
from the o/s such that it would run as a background process?
Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
Where in the Oracle directory tree structure are audit
traces placed?
43
A table is classified as a parent table and you want to drop
and re-create it. How would you do this without affecting
the children tables?
59
Describe what redo logs are.
43
I want to export only structure of the table from oracle
database. In that table to used the some partition.
To export the table in general way then compilation error
was occured i.e-EXP-00003: no storage definition found for
segment(11, 2771). Please tell me the correct export command
parameter to export the partitioned table.
Thanks in Advance..........
46
What are the steps you will take, if you are tasked with
securing an SQL Server?
57
How to make a replica of existing oracle server to another
server?
21
What column differentiates the V$ views to the GV$ views and
how?
150
What are statistics, under what circumstances they go out
of date, how do you update them?
69
What command would you use to create a backup control file?
61
what is the last version,the release date of that version
and fix pack of ibm db2 udb?
29
Explain materialized views and how they are used.
41
. I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman.
My catalog db is called rman. How would you run this shell
script
from the o/s such that it would run as a background process?
Site Map