| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 8 months |
| seen | yesterday | |
| stats | profile views | 6 |
|
May 12 |
comment |
Mistake during Oracle 11g PITR Just wondering, when using the syntax set until time "to_date('05/09/2013 06:10', 'MM/DD/YYYY HH:MI')"; Isn't he missing the AM/PM indicator? :). Other option would be HH24:MI |
|
May 7 |
comment |
Duplicating a Database with RMAN I cannot at this time. The link I provided should suffice to give you enough information. When using the duplicate from active database you won't need the backup files. It will start from the datafiles present on the source and recover using the archives. There might be something else you'll need to pay attention for, that is if the file structure is not the same. You'll have to make the proper adjustments in the duplicate block or in the spfile/pfile. I assume you have a test setup? Play a bit with it. Report the failures. |
|
May 6 |
answered | Duplicating a Database with RMAN |
|
Feb 20 |
comment |
What's a free client for Oracle 8 on Linux / Ubuntu? I use sqltools. It's awesome. sqltools.net |
|
Feb 14 |
comment |
Creating new database and insert values in Oracle 10g xe hr account? Just quick: the xe is a database with hr/hr schema and several others pre installed. You can start creating tables in the hr schema. |
|
Nov 8 |
comment |
How do I generate a tnsnames.ora file to connect to an Oracle Database? Honestly it is the default on a linux system... If you don't touch a thing it will be put there... thus being the default. But $ORACLE_HOME if not tampered with is indeed a better solution. |
|
Nov 7 |
awarded | Editor |
|
Nov 7 |
revised |
How do I generate a tnsnames.ora file to connect to an Oracle Database? added 11 characters in body |
|
Nov 7 |
comment |
How do I generate a tnsnames.ora file to connect to an Oracle Database? the netca is started as the first step. The dbca won't allow you to continue without having created a listener. This is the case for 11g anyway. |
|
Nov 7 |
answered | How do I generate a tnsnames.ora file to connect to an Oracle Database? |
|
Sep 27 |
comment |
Which oracle (10g) template files (DBCA) can be be copied to different server for cloning? Just get the pfile from the other database, edit proper paths. Create a spfile from the pfile ( dba-oracle.com/concepts/pfile_spfile.htm ) |
|
Sep 20 |
awarded | Analytical |
|
Sep 20 |
awarded | Supporter |
|
Sep 18 |
awarded | Teacher |
|
Sep 18 |
answered | Do I have to pay a license fee for Berkeley DB? |