Renaming Or Relocating System Data File
Aug 30, 2012How can we Rename or Relocate the SYSTEM datafile?
View 3 Replies
ADVERTISEMENT
SQL & PL/SQL :: Renaming A File From Package?
Sep 20, 2011I have another question to ask on packages..
I have a dictionary under the schema
OWNERSYS
DIRECTORY_NAMEUTL
DIRECTORY_PATHc:oracleoradataspmap1utl
I have cretaed an external table to read data to a table from a csv file placed in "c:oracleoradataspmap1utl". The csv file name is say "pildata.csv"
I have cretaed a package to read data from the exteranl table and to insert it into a table.
INSERT INTO M_PILEINT SELECT
A.AREA AS "AREA",
A.SUB_FAC_DESC AS "SUB_FAC_DESC",
A.SCOPE_DETAIL AS "SCOPE_DETAIL",
A.MTO_ISSUE_DATE AS "MTO_ISSUE_DATE",
A.MTO_TAKE_BY AS "MTO_TAKE_BY",
A.COMMODITY_CODE AS "SECTION"
A.PILE_NAME AS "PILE_NAME"
FROM M_EXE_PILE A
(where M_EXE_PILE A is the external table which is reading from pildata.csv)
The package runs good and data is populated to M_PILEINT .Is there a way , I can rename the csv file (say to pildata_logxxxx.csv.. something like that) from within the package.Whenever the package is run , it will copy the data from exteranl table and renames the csv file to something else..?
System Tablespace - File Contains Used Data Beyond Requested RESIZE Value
Oct 23, 2012I'm trying to increase the size of my system tablespace. The tablespace contains one datafile size 900MB and it can increase to 2GB.
I'd like to change this to autoextend as I'm going to run csscan on the database.
When I do change the autoextend and unlimited part of the file I get: ORA-03297: file contains used data beyond requested RESIZE value
I've also tried to increase the datafile to 4GB but still the same. I can see that there is more then enough space on the filesystem.
Oracle Enterprise edt 10.2.0.5
Server Administration :: Database File System Architecture For Data Warehouseing Application
Mar 14, 2011Which is the best possible way of configuring the Physical file structure in case of Data Warehouseing application?
I mean to ask you Multiplexing of the data file or control file is required. Or any best possible way to configure Physical file structure.
Data Guard :: Renaming DBName And Instance Name
Jul 13, 2010We are planning to change the dbname from appr to apdr. Its a DR (Standby Database).
a. NID option will work for this? - DB in mount state (Standby db)
b. Is that possible to change the Instance name also?
c. Any Prerequsities and postrequirments for this change? (ie,Data Broker, communication with Primary and Standby etc?
Oracle 10g, OS - Sun Solaris
Importing Dmp File From One To Another System
Jul 23, 2013I have a dmp files of one table . the dmp files are from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
I want to export into my oracle db. i have not create any db or tables . i just installed oracle 11g.
Forms :: Retrieving Images From File System
Sep 15, 2010I am trying to retrieve images from the file system, but the open dialog box is not popping up for me to choose which file i want. It does nothing gives no error. Just says record 1/1 on the message bar at runtime.
I have two blocks on the module. One is the lobs_table block and the other is the control block. On the control block i have a when-button-pressed trigger on an item. And here is the code below.
Declare
jpg_image_dir VARCHAR2(100) := 'C:UsersajayiaDesktopMe_pics';
photo_filename VARCHAR2(100);
BEGIN
:System.Message_Level := '25';
[code]......
I don't know the code to use to get forms to bring up the open dialog box.
Possible To Avoid Encoding When Storing CLOB To File System
Oct 21, 2010I am working with oracle 10g / 11. I need to operate with CLOB values of some table, unknown for me: I read them from .Net (3.5), and have to save them to files (Windows) to be loaded after this with DBMS_LOB. Lets say that table contains 3 columns (1 - CLOB) and several rows.
I want to store each CLOB value to separate file, and to store it after this into another DB table (another Instance, also). I cannot use dblinks and other techniques like this. The point is - how to avoid dealing with encoding?
I mean, that in the best scenario, I just want to save the CLOB values to the files, with no meter about Database Instance character set, language, and so on. How this can be accomplished? If I use default for .Net StreamReader UTF-8 format, the loading with DBMS_LOB failed.
If this is not possible, what will be the best way to determine the encoding, and to convert Oracle used encoding to .Net one?
10g RAC HP-UX To AIX Cross Platform Migration Along With Raw File System To ASM Conversion?
May 7, 2011We got a request from Customer to migrate a RAC database of size 1.8TB from HP unix raw file system to AIX ASM with a min downtime. I have seen lot of methods of doing cross plat form migration and non-ASM to ASM but not together.
Do we have any proven method for migration such cross platform migration with raw file system to ASM conversion in a single go with min downtime?
Server Administration :: Move File System Datafile To ASM
Oct 23, 2012I mistakenly added a datafile to a tablespace which is asm, however the datafile was created in a default location and not the asm location:
alter tablespace pdaiidata1 add datafile '<filename>' size 2048M;
What I should have done:
alter tablepsace <tablespace_name> add datafile '+DATA1' size 2048M;
Is there any way to move this filesystem datafile into the asm tablespace? In previous Oracle versions, I've taken a tablespace offline, moved a datafile, renamed it, then brought the tablespace back online. Can I do something similar here in this situation?
RAC & Failsafe :: Create Shared File System Between Two Desktop PC?
May 14, 2013We are setting RAC between two machines(Desktop PC connected wirth LAN ....have storage Local to them and no Shared storage..Only NFS).We have shared the mount point by NFS.We do not have any shared storage but we need to share the RAW files to setup the OCR and VOTING DISKS.
The problem is:
1. We need to keep the RAW devices for OCR and voting disk common to the machines (Desktop PC..both Linux OELU5). I am able to create the raw file systems but that is local to one machine. I am not able to understand how to share the raw devices between two machines.
2. Tried to use ISCSI utility but that did not work. (How_to_use_iSCSI_Targets_on_Linux)
Scenario : One Machine has 500 GB Storage. Second machine has 80 GB Storage. Made private and public networks(Used two Network cards in LAN). All are communicating.
Problem : Need to make the storage 300GB (Out of 500 GB) of Machine 1 as shared storage. How can we do that? (Do we need any virtual software...ex .. vmware for that?)
SQL & PL/SQL :: Send Mail From Procedure With Attach From File System
Apr 5, 2011I can send mail with UTL_MAIL using this:
CREATE OR REPLACE PROCEDURE send_mail_file_seti IS
BEGIN
UTL_MAIL.SEND_ATTACH_VARCHAR2(
sender => 'mail@from.com',
recipients => 'mail@to.com',
message => '<HTML><BODY>See attachment</BODY></HTML>',
[code]........
What I want to do is send mail attaching a file from file system. For example, I have this file:
/oracle/pmp/file
I want to send it using a procedure like the one above.
RAC/ASM Clusterware Installation :: File System Storage Option On 10g?
Sep 30, 2013We have two database servers(10g with OEL 5) to be clustered and two visible disk groups to each of those nodes. So question is can we choose only one disk group as a shared storage leaving the rest one as the redundant copy during database a creation window while installing the database. Because some of us argue that oracle database has a built-in capability to decide on what level of RAID we store our data.
View 7 Replies View RelatedPL/SQL :: ORA-29283 Invalid File Operation On Windows System
Jul 31, 2012Windows 2003, DB 10.2.0.3...I have to read some files from remote folder, so on remote Windows machine I shared folder c:est (grant Everyone first, and Administrator then) and on DB Server I mapped the remote folder with letter T..All these operations were made with administrator privileges.
In Oracle I create a directory object with this command:
CREATE OR REPLACE directory T_DIR AS 'T:';
Then I granted read and write privileges to my user
GRANT READ, WRITE ON DIRECTORY T_DIR TO <user>; (I tried also to set PUBLIC and SYSTEM)
But when I try to open a file with UTL_FILE with this command
file_handler := UTL_FILE.fopen( 'T_DIR', 'Dati.ini', 'r' ) ;
the error is
Exception: ORA-29283: operazione file non valida
ORA-06512: a "SYS.UTL_FILE", line 475
ORA-29283: operazione file non valida
If I change my directory object in 'C: est' (local folder) it works correctly.I tried also restart DB while shared folders were connected but with the same result.I tried, from sqlplus, the command host (dir t:) and it works (folder is accessible)
Is it an Oracle bug? Is it a Windows bug?
RMAN :: So Many Backup-pieces After Adding New File System
Jun 10, 2012I faced one strange behaviour of rman backup after adding new file system for datafiles . I have OMF datafiles . 4 days ago i had only one file system /data01 and my DB_CREATE_FILE_DEST is set to /data01. my rman backup was creating 14 to 15 bacup pieces with parallelism 5 . which is normal with 84 datafiles .Now i added one more file system /data02 . but after adding this file system rman backup is creating so many backup-pieces around (40-45) with same rman configuration . nothing changes at rman script .
View 3 Replies View RelatedSQL & PL/SQL :: Avoid Encoding Dealing When Storing CLOB To File System?
Oct 21, 2010I am working with oracle 10g / 11. I need to operate with CLOB values of some table, unknown for me: I read them from .Net (3.5), and have to save them to files (Windows) to be loaded after this with DBMS_LOB. Lets say that table contains 3 columns (1 - CLOB) and several rows.I want to store each CLOB value to separate file, and to store it after this into another DB table (another Instance, also).I cannot use dblinks and other techniques like this.
The point is - how to avoid dealing with encoding?
I just want to save the CLOB values to the files, with no meter about Database Instance character set, language, and so on. If I use default for .Net StreamReader UTF-8 format, the loading with DBMS_LOB failed.
what will be the best way to determine the encoding, and to convert Oracle used encoding to .Net one?
Server Administration :: Running Out Of Space For Archive File System
Apr 2, 2012In normal days size of archives generated in a day is 14-15GB. But since yesterday morning, almost 150GB of archives have been generated and are still getting generated(200MB every 1-2 minutes).
There was a sudden reboot of server yesterday morning. At that time there was heavy load of transactions on database. Can it be a reason that smon is still doing recovery? (I am not sure on this). Also, Undo tablespace is increased from 18 GB to 50 GB since yesterday (autoextend on).
Now we are running out of space for archive file system (can't delete them also until they are transferred to DR) Size of redo log is 200MB. This database supports around 2500 users.
performance wise I don't see any hit. Also wait events are normal. (only few db file sequential read) finding the query/session which are causing this much huge amount of archives?
RESUMEABLE Parameter / No Space Left On File System Export Fails
Dec 2, 2010I have some question about the parameter RESUMABLE 10G. My quesition is suppose if i am running a expdp process and if there is no space left on the file system the export fails. So in this case if we set the RESUMABLE parameter in the DB will it be useful to resume the expdp from where it fails or it will useful if we schedule a job for the export.
View 2 Replies View RelatedForms :: Replica Of Windows Explorer - Read UNIX File System
Jun 14, 2011I would like to develop a form which will be replica of windows explorer.It should be able to read all files or files from a specific folder from an unix platform.
if yes can i have a template. I do not want to start from the scratch since I do not have much time.
Recovery Manager (RMAN) :: Duplicate Database From ASM To Non-ASM File System To Remote Machine
Aug 30, 2012I have oracle 11.2.0.3.0 in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?
Can i keep the database name as ASMDB in another Machine ?
SQL & PL/SQL :: Renaming A Column
Apr 27, 2012i have a problem in renaming the column of a table and it throws a strange error-"ORA-14155: missing PARTITION or SUBPARTITION keyword " ,but i have used correct syntax which is that " alter table temp rename id to num; " where is the problem.
View 2 Replies View RelatedServer Administration :: Renaming A DB?
Mar 10, 2011I would like to try to rename a newly created dB. Referring to the topic posted on your website[URL]... had some clarification before executing the dbrename.sql mentioned there:
After modifying the the init.ora and tnsnames.ora, do I have to rename all OLD, existing directory path (for controlfiles, datafiles, etc.) with the new-- meaning I don't have to create another directory for it's 'NEW' name?
PL/SQL :: Renaming View From Another Schema?
Aug 1, 2013I've 2 schemas namely department, hrNow department schema is having one table EMP . And a view is created on that table with the name R_EMPSchema Name :
departmentTable Name : EMPView Name : R_EMPGRANT SELECT ON R_EMP TO HR ; In HR schema a synonym has been created on view R_EMP with the name R_EMP .CREATE OR REPLACE SYNONYM hr.R_EMP for department.R_EMPSchema Name : hr Synonym Name: R_EMP
Now I want to rename the view name R_EMP to V_EMP from HR schema only So, I tried the folloiwng syntax in HR schema (All the operations should be done from this schema only )[code] RENAME department.R_EMP to department.V_EMP ;
Error: ORA-01765: specifying table's owner name is not allowed[/code] How to change the syntax to make the statement work from HR schema .
SQL & PL/SQL :: Column Renaming From Query Output?
Jul 14, 2010I want to be able to name a column created from my query.
Query is:
select A.OrigRef, A.DisplayName, A.ExtCode, count(CalcId)
from OrigRefView A, CalcView B where A.OrigRef = B.NewRef and A.OrigRef like 'AB%'
group by A.OrigRef, A.DisplayName, A.ExtCode
order by A.SusRef
and it returns the Count in "column4" Is there a way I can get the query to output a different column name without creating a whole new table (i.e. not by creating a new table for my query output and then running a new procedure at the end to rename the column...)?
i.e. I want "column4" to read "CountofCalId"
SQL & PL/SQL :: Renaming Column In Multiple Procedures?
Jun 2, 2010Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"
Is there any way to rename a column in a table A, so that it is changed wherever it is used, like all the procedures that uses this column, or other tables that has reference to this table A?
Forms :: Difference Between System.current_item And System.cursor_item?
Apr 1, 2012We have system.current_item and system.cursor_item.....
both represent the same....
like this we have few other system variables also .....
what is the main difference between current_item and cursor_item?
CPU System Time (percentage) For Multi Core System?
Aug 21, 2012couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not
CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)
Server Administration :: Renaming Datafile - Change Name In OS Level Also
Nov 3, 2012While renaming the datafile.
1) ALTER TABLESPACE .... OFFLINE;
2) CHANGING THE DATAFILE NAME IN OS LEVEL;
3) ALTER TABLESPACE .... RENAME DATAFILE 'FILE_OLD' TO 'FILE_NEW';
4) ALTER TABLESPACE .... ONLINE;
In the above steps, I HAD FORGOTTON TO FOLLOW THE 2ND STEP.
At the step of 3rd, i got error message, now i am not able to change the name in OS level Also.
Server Administration :: Renaming Listener Log_file On 11gr2?
Nov 9, 2012LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 09-NOV-2012 19:55:06
Uptime 0 days 0 hr. 24 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:oracleproduct11.2.0dbhome_1
etworkadminlistener.ora
Listener Log File c:oraclediag nslsnrTESTQ51listeneralertlog.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NDCORCKSDQ51.global.loc)(PORT=1521)))
Services Summary...
Service "testdb" has 1 instance(s).
Instance "ksdtest", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
Instance "testdb", status READY, has 1 handler(s) for this service...
The command completed successfully
i am trying to rename the logfile
"c:oraclediag nslsnrTESTQ51listeneralertlog.xml" to "c:oraclediag nslsnrTESTQ51listeneralert estdb.log"
so far i tried
LSNRCTL> set log_file testdb.log
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-01251: Cannot set trace/log directory under ADR
LSNRCTL>
SQL & PL/SQL :: Interfacing Data From Oracle Database To External System
Feb 24, 2012I have an issue with the text area column(Column name-Text) while interfacing the data from oracle database to external system.The data in database is saved as:
This is test entry for commentfield.
testing the script
Pre-production
23-FEB-2012
We want all the line breaks to replaced with a space or a comma. to implement this i have used to simple select as :
Select Replace(text,chr(10),'')
From paymemo
where referencepkey = (select pkey from paymain where ID = 'DED-520074 505354DN6 2012-02-04 00:06:48');
This is not working because of type conversion issues.