move oracle

search for more blogs here

 

"FNDLOAD" posted by ~Ray
Posted on 2008-09-28 02:27:06

Data Synchronization: Data Synchronization is a process in which some setup data would be synchronized and this would be more important when you are working in oracle application development/implementation project. The equally important that AOL data Migration takes place necessary to synchronize the data across databases instance during FNDLOAD is one and only oracle solution. It can be defined as a concurrent program that can move Oracle Applications data between database and text file representations. Or this can be defined as FNDLOAD can download data from an application entity into an editable text file which can be uploaded to another database. Working of FNDLOAD: Conversion between database format and text file format is specified by a configuration file. Oracle does provide configuation file and it is important to just pass the configuration file name and then just label the loader and leave everything. Modes of Operation:Two modes.. Upload and Download…1. Example of download: FNDLOADapps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog lct myfile ldt \ schedule CONCURRENT_schedule_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME= Entire OR Partial upload of a data file: Upload the entire myfile ldt or just a single enity indicated by - and mode transfer or UPLOAD_PARTIAL On Unix - all the configuration files are in $FND_TOP/patch/115/import directoryOn Unix – Oracle also places the original configuration files in $FND_TOP/admin/merchandise directory Use the log file outputs or ldt file contents creatively for quick file comparisons and answer questions faster (Why can’t I access that? What is that profile option label value and level? What is the value set used for that DFF segment attribute10 etc.) Partial string searches (which value set has Priority “something” in its where clause? etc) 1 - Printer StylesFNDLOAD apps/apps@disgorge115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl lct file_name ldt STYLE PRINTER_call_NAME=”printer style label” 2 - LookupsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/conjoin/115/import/aflvmlu lct file_name ldt FND_LOOKUP_TYPE APPLICATION_bunco_label=”prod” LOOKUP_TYPE=”lookup name” 3 - Descriptive Flexfield with all of specific ContextsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_label ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=”prod” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name” 4 - Key Flexfield StructuresFNDLOAD apps/apps@disgorge115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_name ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_label=”prod” ID_FLEX_CODE=”key flex code” P_STRUCTURE_CODE=”coordinate name” 5 - Concurrent ProgramsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog lct file_name ldt PROGRAM APPLICATION_SHORT_NAME=”prod” CONCURRENT_PROGRAM_NAME=”concurrent name” 6 - Value SetsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/conjoin/115/merchandise/afffload lct file_name ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name” 7 - Value Sets with valuesFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_name ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name” 8 - Profile OptionsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof lct file_name ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”prod” 9 - Requset GroupFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg lct file_name ldt REQUEST_assort REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”prod” 10 - communicate SetsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset lct file_name ldt REQ_SET APPLICATION_SHORT_NAME=”prod” REQUEST_SET_NAME=”request set” 11 - ResponsibilitiesFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/conjoin/115/import/afscursp lct register_name ldt FND_RESPONSIBILITY RESP_KEY=”responsibility 12 - MenusFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/conjoin/115/import/afsload lct file_name ldt MENU MENU_NAME=”menu_name” 13 – Forms/FunctionsFNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus lct file_name ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus lct file_label ldt 14. User/ResponsibilitiesFNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp lct file_name ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp lct file_name ldt FND_USER [ Hello. This post is likeable and your blog is very interesting congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog it is about the. I hope you enjoy. The address is http://estabilizador-e-nobreak blogspot com. A hug. The Oracle Financials blog is setup and founded by me Ajeet Singh. The idea behind this blog is to keep a track of my learning in Oracle Applications. The material is useful for beginner apps users who can have a glipmse of Oracle apps and professionals preparing for Oracle Professional Certifications. Your feedback and comments are much appreciated and provide me the fuel so comment please. Do reach me at

Forex Groups - Tips on Trading

Related article:
http://asoracle.blogspot.com/2007/11/fndload.html

comments | Add comment | Report as Spam


"FNDLOAD" posted by ~Ray
Posted on 2008-09-28 02:26:57

Data Synchronization: Data Synchronization is a process in which some setup data would be synchronized and this would be more important when you are working in oracle application development/implementation project. The equally important that AOL data Migration takes place necessary to synchronize the data across databases instance during FNDLOAD is one and only oracle solution. It can be defined as a concurrent program that can move Oracle Applications data between database and text file representations. Or this can be defined as FNDLOAD can download data from an application entity into an editable text file which can be uploaded to another database. Working of FNDLOAD: Conversion between database format and text file format is specified by a configuration register. Oracle does provide configuation file and it is important to just pass the configuration file name and then just call the loader and get everything. Modes of Operation:Two modes.. Upload and Download…1. Example of download: FNDLOADapps/pwd 0 Y transfer ${FND_TOP}/patch/115/import/afcpprog lct myfile ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_bunco_NAME= Entire OR Partial upload of a data file: Upload the entire myfile ldt or just a single enity indicated by - and mode UPLOAD or transfer_PARTIAL On Unix - all the configuration files are in $FND_TOP/patch/115/import directoryOn Unix – Oracle also places the original configuration files in $FND_TOP/admin/import directory Use the log file outputs or ldt register contents creatively for quick file comparisons and answer questions faster (Why can’t I access that? What is that profile option name value and level? What is the value set used for that DFF segment attribute10 etc.) Partial string searches (which value set has Priority “something” in its where clause? etc) 1 - Printer StylesFNDLOAD apps/apps@seed115 O Y transfer $FND_TOP/patch/115/import/afcppstl lct file_name ldt STYLE PRINTER_STYLE_NAME=”printer call name” 2 - LookupsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu lct file_name ldt FND_LOOKUP_TYPE APPLICATION_bunco_NAME=”prod” LOOKUP_TYPE=”lookup name” 3 - Descriptive Flexfield with all of specific ContextsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_name ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=”prod” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name” 4 - Key Flexfield StructuresFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/conjoin/115/import/afffload lct file_name ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=”prod” ID_contract_CODE=”key flex code” P_STRUCTURE_CODE=”structure name” 5 - Concurrent ProgramsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog lct file_name ldt PROGRAM APPLICATION_SHORT_NAME=”prod” CONCURRENT_PROGRAM_NAME=”concurrent name” 6 - Value SetsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_name ldt VALUE_SET FLEX_determine_SET_NAME=”value set name” 7 - determine Sets with valuesFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_name ldt VALUE_SET_VALUE FLEX_VALUE_SET_label=”value set name” 8 - Profile OptionsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof lct file_name ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”prod” 9 - Requset GroupFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg lct file_name ldt communicate_GROUP REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_label=”prod” 10 - Request SetsFNDLOAD apps/apps@disgorge115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset lct register_name ldt REQ_SET APPLICATION_SHORT_NAME=”prod” REQUEST_SET_NAME=”request set” 11 - ResponsibilitiesFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp lct file_label ldt FND_RESPONSIBILITY RESP_KEY=”responsibility 12 - MenusFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload lct file_name ldt MENU MENU_NAME=”menu_name” 13 – Forms/FunctionsFNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/conjoin/115/import/affrmcus lct register_label ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus lct register_name ldt 14. User/ResponsibilitiesFNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/merchandise/afscursp lct file_name ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp lct file_name ldt FND_USER [ Hello. This post is likeable and your blog is very interesting congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog it is about the. I hope you enjoy. The address is http://estabilizador-e-nobreak blogspot com. A hug. The Oracle Financials blog is setup and founded by me Ajeet Singh. The idea behind this blog is to keep a bring in of my learning in Oracle Applications. The material is useful for beginner apps users who can have a glipmse of Oracle apps and professionals preparing for Oracle Professional Certifications. Your feedback and comments are much appreciated and give me the fuel so comment please. Do reach me at

Forex Groups - Tips on Trading

Related article:
http://asoracle.blogspot.com/2007/11/fndload.html

comments | Add comment | Report as Spam


"FNDLOAD" posted by ~Ray
Posted on 2008-09-28 02:26:57

Data Synchronization: Data Synchronization is a affect in which some setup data would be synchronized and this would be more important when you are working in oracle application development/implementation project. The equally important that AOL data Migration takes place necessary to synchronize the data across databases instance during FNDLOAD is one and only oracle solution. It can be defined as a concurrent program that can move Oracle Applications data between database and text file representations. Or this can be defined as FNDLOAD can download data from an application entity into an editable text file which can be uploaded to another database. Working of FNDLOAD: Conversion between database format and text file format is specified by a configuration file. Oracle does give configuation file and it is important to just pass the configuration file name and then just call the loader and leave everything. Modes of Operation:Two modes.. Upload and Download…1. Example of download: FNDLOADapps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog lct myfile ldt \ PROGRAM CONCURRENT_schedule_NAME= concurrent_schedule_bunco_name> APPLICATION_SHORT_NAME= Entire OR Partial transfer of a data file: Upload the entire myfile ldt or just a single enity indicated by - and mode UPLOAD or UPLOAD_PARTIAL On Unix - all the configuration files are in $FND_TOP/patch/115/import directoryOn Unix – Oracle also places the original configuration files in $FND_TOP/admin/import directory Use the log file outputs or ldt file contents creatively for quick file comparisons and answer questions faster (Why can’t I find that? What is that profile option name value and aim? What is the value set used for that DFF segment attribute10 etc.) Partial string searches (which value set has Priority “something” in its where clause? etc) 1 - Printer StylesFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/conjoin/115/import/afcppstl lct file_name ldt call PRINTER_STYLE_NAME=”printer call name” 2 - LookupsFNDLOAD apps/apps@disgorge115 O Y DOWNLOAD $FND_TOP/conjoin/115/merchandise/aflvmlu lct file_name ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”prod” LOOKUP_TYPE=”lookup name” 3 - Descriptive Flexfield with all of specific ContextsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_name ldt DESC_FLEX P_aim=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=”prod” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name” 4 - Key Flexfield StructuresFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct file_name ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=”prod” ID_FLEX_CODE=”key flex code” P_STRUCTURE_CODE=”structure name” 5 - Concurrent ProgramsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog lct file_name ldt PROGRAM APPLICATION_SHORT_NAME=”force” CONCURRENT_schedule_NAME=”concurrent name” 6 - Value SetsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct register_name ldt determine_SET FLEX_determine_SET_NAME=”value set name” 7 - Value Sets with valuesFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload lct register_name ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name” 8 - Profile OptionsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/merchandise/afscprof lct file_name ldt PROFILE compose_label=”profile option” APPLICATION_bunco_NAME=”prod” 9 - Requset GroupFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/merchandise/afcpreqg lct file_label ldt REQUEST_assort REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”prod” 10 - Request SetsFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/merchandise/afcprset lct file_name ldt REQ_SET APPLICATION_SHORT_NAME=”prod” communicate_SET_NAME=”request set” 11 - ResponsibilitiesFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp lct file_name ldt FND_RESPONSIBILITY RESP_KEY=”responsibility 12 - MenusFNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload lct file_name ldt MENU MENU_NAME=”menu_name” 13 – Forms/FunctionsFNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus lct file_name ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus lct file_name ldt 14. User/ResponsibilitiesFNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp lct file_name ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp lct file_label ldt FND_USER [ Hello. This post is likeable and your blog is very interesting congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog it is about the. I hope you enjoy. The address is http://estabilizador-e-nobreak blogspot com. A hug. The Oracle Financials communicate is setup and founded by me Ajeet Singh. The idea behind this blog is to keep a track of my learning in Oracle Applications. The material is useful for beginner apps users who can have a glipmse of Oracle apps and professionals preparing for Oracle Professional Certifications. Your feedback and comments are much appreciated and provide me the fuel so comment please. Do arrive me at

Forex Groups - Tips on Trading

Related article:
http://asoracle.blogspot.com/2007/11/fndload.html

comments | Add comment | Report as Spam


"Re: Move Order Transact APIs" posted by ~Ray
Posted on 2008-03-15 23:24:27

About oracle-apps-lThe ITtoolbox Oracle-Apps-L discussion group is for the discussion of issues that arise during the installation or daily administration of Oracle applications. Sample topics of discussion include development challenges bugs errors and end-user issues. Hi. The transact move order API is working fine. Can i experience the Backorder API while doing choose affirm. Requirement goes we undergo designed a form in which we have to confirm the picked qty be say picked qty-5 confirm the picked qty-4 missing qty-1 if the picked qty is greater than confirmed qty then remaining qty (1) has to be backordered when i do the move order transact in list. Is this the same API WSH_DELIVERIES_PUB. Delivery_Action that works on while choose CONFIRM. thanks n advance. 98845 93016. The information entered on this summon is required only to route your message to the appropriate people. It will not be used to send unsolicited email and ordain not be sold to a 3rd party. Please to read our detailed privacy policy. Hi. The transact move order API is working fine. Can i know the Backorder API while doing Pick affirm. Requirement goes we undergo designed a form in which we have to confirm the picked qty amount say picked qty-5 confirm the picked qty-4 missing qty-1 if the picked qty is greater than confirmed qty then remaining qty (1) has to be backordered when i do the move order transact in inventory. Is this the same API WSH_DELIVERIES_PUB. Delivery_challenge that works on while PICK affirm thanks n advance. 98845 93016. You must be logged in to use the Blog-to-ITtoolbox Journal feature. gratify or for an ITtoolbox account. You will be returned to this page after logging in. procure © 1998-2008 Information Technology Toolbox. Inc. All product names are trademarks of their respective companies. Information Technology Toolbox. Inc is not affiliated with or endorsed by any company listed at this place.

Forex Groups - Tips on Trading

Related article:
http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/1679135&rss=1

comments | Add comment | Report as Spam


"Re: Move Order Transact APIs" posted by ~Ray
Posted on 2008-03-15 23:24:27

About oracle-apps-lThe ITtoolbox Oracle-Apps-L discussion group is for the discussion of issues that become during the installation or daily administration of Oracle applications. Sample topics of discussion include development challenges bugs errors and end-user issues. Hi. The interact move request API is working fine. Can i know the Backorder API while doing choose Confirm. Requirement goes we have designed a form in which we have to confirm the picked qty amount say picked qty-5 affirm the picked qty-4 missing qty-1 if the picked qty is greater than confirmed qty then remaining qty (1) has to be backordered when i do the move order interact in inventory. Is this the same API WSH_DELIVERIES_PUB. Delivery_Action that works on while choose CONFIRM. thanks n advance. 98845 93016. The information entered on this page is required only to route your message to the appropriate people. It will not be used to send unsolicited telecommunicate and will not be sold to a 3rd celebrate. gratify to read our detailed privacy policy. Hi. The transact move request API is working fine. Can i know the Backorder API while doing choose affirm. Requirement goes we have designed a create in which we have to confirm the picked qty amount say picked qty-5 confirm the picked qty-4 missing qty-1 if the picked qty is greater than confirmed qty then remaining qty (1) has to be backordered when i do the move order transact in inventory. Is this the same API WSH_DELIVERIES_PUB. Delivery_Action that works on while PICK CONFIRM thanks n advance. 98845 93016. You must be logged in to use the Blog-to-ITtoolbox Journal feature. Please or for an ITtoolbox account. You ordain be returned to this page after logging in. Copyright © 1998-2008 Information Technology Toolbox. Inc. All product names are trademarks of their respective companies. Information Technology Toolbox. Inc is not affiliated with or endorsed by any affiliate listed at this site.

Forex Groups - Tips on Trading

Related article:
http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/1679135&rss=1

comments | Add comment | Report as Spam


"Re: Move Order Transact APIs" posted by ~Ray
Posted on 2008-03-15 23:24:27

About oracle-apps-lThe ITtoolbox Oracle-Apps-L discussion group is for the discussion of issues that arise during the installation or daily administration of Oracle applications. consume topics of discussion include development challenges bugs errors and end-user issues. Hi. The interact move order API is working fine. Can i know the Backorder API while doing Pick Confirm. Requirement goes we have designed a form in which we undergo to confirm the picked qty be say picked qty-5 confirm the picked qty-4 missing qty-1 if the picked qty is greater than confirmed qty then remaining qty (1) has to be backordered when i do the move order transact in inventory. Is this the same API WSH_DELIVERIES_PUB. Delivery_Action that works on while choose affirm. thanks n advance. 98845 93016. The information entered on this summon is required only to despatch your message to the appropriate populate. It ordain not be used to send unsolicited email and will not be sold to a 3rd party. Please to read our detailed privacy policy. Hi. The transact move request API is working fine. Can i experience the Backorder API while doing Pick affirm. Requirement goes we have designed a create in which we have to affirm the picked qty be say picked qty-5 confirm the picked qty-4 missing qty-1 if the picked qty is greater than confirmed qty then remaining qty (1) has to be backordered when i do the move order transact in inventory. Is this the same API WSH_DELIVERIES_PUB. Delivery_Action that works on while PICK CONFIRM thanks n go. 98845 93016. You must be logged in to use the Blog-to-ITtoolbox Journal feature. gratify or for an ITtoolbox be. You will be returned to this page after logging in. Copyright © 1998-2008 Information Technology Toolbox. Inc. All product names are trademarks of their respective companies. Information Technology Toolbox. Inc is not affiliated with or endorsed by any company listed at this site.

Forex Groups - Tips on Trading

Related article:
http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/1679135&rss=1

comments | Add comment | Report as Spam


"Oracle 10g Database clone via Data file move" posted by ~Ray
Posted on 2008-01-01 22:13:22

Recently I had an oppertunity to do some database work for a company in Michigan. To alter for this I found out the company was using Oracle's 10g database product. To be honest I had never done a database copy before on a 10g system. So for the Noobs out there I think I'll include step by go instructions of what I did. There are some PROBLEMS WITH 10g CLONE see optional stepsSource Database: HRPRDTarget Database: HRTESTStep 1. Step4. Navigate to the location of your trc files. choose by date and write the most current out somewhere to be edited. Then cut out the following divide and deliver it as createnewdb sql:STARTUPNOMOUNTCREATECONTROLFILE apply DATABASE "OLDLSQ" NORESETLOGSNOARCHIVELOGMAXLOGFILES 16MAXLOGMEMBERS 2MAXDATAFILES 240MAXINSTANCES 1MAXLOGHISTORY 113LOGFILEGROUP 1 ('/u03/oradata/oldlsq/log1a dbf','/u03/oradata/olslsq/log1b dbf') coat 30M,assort 2 ('/u04/oradata/oldlsq/log2a dbf','/u04/oradata/oldlsq/log2b dbf') coat 30MDATAFILE'/u01/oradata/oldlsq/system01 dbf','/u01/oradata/oldlsq/mydatabase dbf';# Recovery is required if any of the datafiles are restored# backups or if the last shutdown was not normal or immediate. acquire DATABASE# Database can now be opened normally. alter DATABASE OPEN;go5. change lines from the "createnewdb sql" we just created:shift the lines following the characterset lines including:# Recovery is required if any of the datafiles are restored# backups or if the last shutdown was not normal or immediate. RECOVER DATABASE# Database can now be opened normally. alter DATABASE OPEN;go6. Do a global replace on the old Database name "HRPRD" with "HRDEV" (without quotes-lol) within the createnewdb sql file. Also change the following like to readbefore changes:CREATE CONTROLFILE REUSE DATABASE "HRPRD" NORESETLOGSafter changes:CREATE CONTROLFILE SET DATABASE "HRDEV" RESETLOGSnote: The instructions I've read everywhere say that you decide the "NORESETLOGS" option when using the "SET" operator. In 10g it explicitly tells me that in order to change the database label you have to use the "RESETLOGS" Option. Disclaimer: I'm no know it all. I do what works :)go7. On your Destination forge(HRDEV). Create a bomb database (using your new DB name "HRDEV") using the Database configuration assistant. Step8. Copy all of the datafiles from the source machine to the target forge (yes the clone is on a displace box)using the "windows copy" option or "cp" for UNIX. Put the files in the same location as where you got them on the Production.

Forex Groups - Tips on Trading

Related article:
http://dbashiz.blogspot.com/2007/10/oracle-10g-database-clone-via-data-file.html

comments | Add comment | Report as Spam


"rename user profile xp" posted by ~Ray
Posted on 2007-12-15 15:13:21

rename folder in unix call folder linux call folder linux command call folder unix rename folder vbscript call folders call folders dos call folders in dos call folders linux rename folders os x call folders windows xp rename font rename fonts call create element with javascript call fraction call fractions rename fractions as decimals call freeware call from call from list call ftp call game files psp call group of files rename groups call hard drive call hard control letter rename hard drive letters rename hard drive mac call hard drive os 9 rename hard drive os x call hard control windows xp rename hard control xp call hard drives call help rename icon call image rename visualise files rename visualise php rename images call in dos rename in linux rename in unix rename inbox rename inbox in outlook 2003 rename inbox outlook rename inbox outlook 2000 rename inbox dbx call instance rename dilate of sql server rename ipod rename ipod files call ipod in itunes call ipod itunes rename ipod mini rename ipod label call ipod shuffle rename ipod walk windows rename ipod windows rename it rename it 3.0 rename it 3.05 call it as call it freeware rename it mac rename it software call it sourceforge rename it to rename itunes songs call earn control call log file rename long file rename long file name rename long register names rename long filename call desire filenames rename machine rename man rename many files rename many files at once call master rename know download call move call mp3 rename mp3 automatically rename mp3 cddb rename mp3 file rename mp3 files rename mp3 files software rename mp3 remove call mp3 freedb rename mp3 id3 call mp3 program call mp3 tag rename mp3 tags call mp3s rename multiple rename multiple file extensions call multiple files rename multiple files at once rename multiple files dos call multiple files in unix rename multiple files in windows rename multiple files in windows xp call multiple files linux call multiple files unix rename multiple files windows rename multiple files windows 2000 rename multiple files windows explorer rename multiple files windows xp rename multiple files xp rename multiple folders call music files rename my computer icon call my documents rename my documents folder rename my communicate linksys rename mysql database call mysql database phpmyadmin call ntuser rename ntuser dat call oracle call oracle column rename oracle columns rename oracle database rename oracle database table rename oracle datafile call oracle datafiles rename oracle index call oracle instance rename oracle schema call oracle table call oracle delay column rename oracle table name call oracle tables rename oracle tablespace rename oracle user rename os x rename os x computer rename personal folders rename personal folders outlook rename photo call photo files call photo with date measure rename photos call conceive of rename pictures call process call program rename program files rename program files directory rename program files folder call cycle bin rename recycle bin icon windows xp-home edition rename recycle bin in windows xp rename recycle bin in xp call cycle bin registry call cycle bin sp2 call recycle bin win xp rename cycle bin windows rename recycle bin windows 2000 call cycle bin windows xp rename recycle bin winxp call cycle bin xp rename remote printer vb compose call risc os call sas rename script rename server rename server 2000 rename server 2003 call server 2003 domain call server exchange call server exchange 2003 rename server exchange 5.5 rename server linux rename server label rename server sql call server sql 2000 rename server sql server rename server sql server 2000 call several files rename several files at once rename shell rename shell script rename shortcut call shortcut key call shortcut windows call show showstopper call software rename software freeware rename sql database rename sql databases call sql server rename sql server 2000 rename sql server 2000 database call sql server computer rename sql server computer label rename sql server database rename sql server database label rename sql server instance rename sql server microsoft rename sql server label call sql server table rename sql table call sql tables rename sqlserver rename sqlserver database rename sqlserver instance rename ssid rename start button rename start add in windows xp rename go away add registry rename start button windows xp call go away add xp rename start menu call go away menu windows xp call go away menu xp rename stored procedure call synonym table rename syntax call system folder call system folder windows xp call system folder xp call system folders rename delay rename delay in mysql call table in oracle call table in oracle 9i rename table in sql call table in sql server call delay in sqlserver rename table mysql call delay oracle rename table oracle 8i call table oracle 9i rename delay oracle sql call delay sql rename table sql oracle rename table sql server rename table sql server 2000 rename delay sqlite rename table sqlserver rename tablespace rename tablespace in oracle call tablespace in oracle 9i call tablespace in oracle9i rename tablespace label rename tablespace oracle call tablespace oracle 9i rename tag rename tag v3.2 rename tags rename the register call the recycle bin call the start add rename to rename to lowercase rename to mp3 call token livejournal rename tokens call drive rename tools call unix rename unix dominate rename unix commands rename unix directory rename unix file rename unix files rename unix folder call unix server call user call user be rename user account active directory call user account linux rename user be compose rename user account vbscript rename user account win2k rename user be windows 2000 rename user account windows xp rename user be xp rename user accounts rename user active directory call user directory rename user directory xp call user folder rename user folder documents and settings call user folder windows xp rename user folder xp call user in oracle rename user linux call user profile call user profile folder rename user compose in windows xp call user compose windows 2000 call user compose windows xp rename user compose xp rename user profiles rename user windows xp call user windows xp domiciliate call user xp rename user xp home rename users rename users in active directory rename utility call vanilla change call variable call variable in sas rename variable sas call variables in sas rename variables sas rename virtual directory call virtual directory iis rename virtual machine rename vlan procurve call vsam call window system folder rename window xp administrator call windows 2000 domain rename windows 2000 domain controller call windows 2003 domain rename windows 2003 domain controller call windows 2003 domain name rename windows folder rename windows folder xp call windows system folder call windows system folder xp rename windows system folders call wrigley rename wrigley handle call your files call your ipod rename zip file call zip files rename+ rename+delay+sql+server rename4u renamed renamed african countries renamed as renamed biologics renamed cities renamed device drivers renamed into renamed invalid pelt name.

Forex Groups - Tips on Trading

Related article:
http://mp3-player-headphone.blogspot.com/2007/11/rename-user-profile-xp.html

comments | Add comment | Report as Spam


"rename user profile xp" posted by ~Ray
Posted on 2007-12-15 15:13:20

call folder in unix rename folder linux call folder linux dominate rename folder unix rename folder vbscript call folders rename folders dos rename folders in dos rename folders linux rename folders os x call folders windows xp rename font rename fonts call form element with javascript rename fraction call fractions call fractions as decimals rename freeware call from call from list rename ftp call bet files psp call group of files rename groups rename hard drive rename hard drive earn rename hard drive letters rename hard drive mac call hard control os 9 call hard drive os x rename hard control windows xp call hard control xp call hard drives call help rename icon rename visualise call image files rename image php rename images rename in dos call in linux rename in unix rename inbox rename inbox in outlook 2003 call inbox outlook rename inbox outlook 2000 rename inbox dbx rename dilate rename dilate of sql server call ipod rename ipod files call ipod in itunes rename ipod itunes rename ipod mini rename ipod name rename ipod shuffle rename ipod shuffle windows call ipod windows call it call it 3.0 call it 3.05 rename it as call it freeware call it mac rename it software rename it sourceforge rename it to call itunes songs call earn drive rename log file rename long file rename desire file name rename long register names rename desire filename rename long filenames rename machine call man rename many files rename many files at once call master rename know download call move rename mp3 rename mp3 automatically call mp3 cddb rename mp3 file call mp3 files call mp3 files software rename mp3 free call mp3 freedb rename mp3 id3 call mp3 program rename mp3 tag call mp3 tags rename mp3s rename multiple call multiple file extensions rename multiple files call multiple files at once call multiple files dos call multiple files in unix call multiple files in windows rename multiple files in windows xp rename multiple files linux rename multiple files unix rename multiple files windows rename multiple files windows 2000 call multiple files windows explorer call multiple files windows xp call multiple files xp rename multiple folders rename music files rename my computer icon rename my documents rename my documents folder rename my network linksys call mysql database rename mysql database phpmyadmin rename ntuser call ntuser dat rename oracle rename oracle column rename oracle columns rename oracle database rename oracle database table call oracle datafile call oracle datafiles rename oracle list rename oracle instance rename oracle schema call oracle table rename oracle table column rename oracle table name call oracle tables call oracle tablespace rename oracle user rename os x call os x computer call personal folders call personal folders outlook rename photo call photo files rename photo with date measure rename photos rename picture call pictures rename process rename schedule rename program files rename program files directory rename program files folder call recycle bin rename cycle bin icon windows xp-home edition rename recycle bin in windows xp rename recycle bin in xp call recycle bin registry rename cycle bin sp2 rename recycle bin win xp call recycle bin windows rename recycle bin windows 2000 rename recycle bin windows xp call cycle bin winxp call cycle bin xp call remote printer vb script call risc os rename sas rename script call server rename server 2000 rename server 2003 rename server 2003 domain call server exchange call server exchange 2003 rename server exchange 5.5 call server linux rename server label rename server sql rename server sql 2000 rename server sql server call server sql server 2000 rename several files call several files at once call bomb rename shell compose rename shortcut call shortcut key call shortcut windows rename show showstopper call software rename software freeware call sql database rename sql databases rename sql server call sql server 2000 rename sql server 2000 database call sql server computer rename sql server computer label rename sql server database rename sql server database name rename sql server instance call sql server microsoft call sql server name rename sql server table call sql table rename sql tables rename sqlserver call sqlserver database rename sqlserver instance call ssid rename start button rename go away button in windows xp rename start add registry call start button windows xp call go away add xp rename start menu rename start menu windows xp rename go away menu xp rename stored procedure rename synonym table rename syntax rename system folder call system folder windows xp rename system folder xp rename system folders rename delay rename delay in mysql call delay in oracle rename delay in oracle 9i rename delay in sql call delay in sql server rename delay in sqlserver rename table mysql call table oracle call delay oracle 8i rename table oracle 9i call table oracle sql call delay sql rename delay sql oracle rename table sql server rename delay sql server 2000 rename delay sqlite call table sqlserver rename tablespace rename tablespace in oracle rename tablespace in oracle 9i rename tablespace in oracle9i call tablespace name call tablespace oracle call tablespace oracle 9i rename tag call tag v3.2 rename tags rename the register rename the cycle bin call the start add rename to rename to lowercase call to mp3 rename token livejournal call tokens rename tool rename tools rename unix call unix dominate rename unix commands call unix directory call unix file rename unix files rename unix folder rename unix server rename user rename user account call user account active directory call user be linux rename user account script rename user account vbscript call user be win2k call user be windows 2000 call user account windows xp call user account xp rename user accounts rename user active directory call user directory rename user directory xp call user folder rename user folder documents and settings rename user folder windows xp rename user folder xp rename user in oracle rename user linux rename user compose rename user profile folder call user profile in windows xp rename user profile windows 2000 rename user profile windows xp rename user compose xp rename user profiles rename user windows xp rename user windows xp home call user xp rename user xp home rename users rename users in active directory rename utility rename vanilla change rename variable rename variable in sas rename variable sas rename variables in sas rename variables sas call virtual directory call virtual directory iis rename virtual machine rename vlan procurve rename vsam call window system folder rename window xp administrator call windows 2000 domain rename windows 2000 domain controller rename windows 2003 domain rename windows 2003 domain controller rename windows 2003 domain name rename windows folder call windows folder xp call windows system folder rename windows system folder xp call windows system folders call wrigley rename wrigley handle rename your files rename your ipod call zip register rename zip files rename+ call+table+sql+server rename4u renamed renamed african countries renamed as renamed biologics renamed cities renamed device drivers renamed into renamed invalid pelt name.

Forex Groups - Tips on Trading

Related article:
http://mp3-player-headphone.blogspot.com/2007/11/rename-user-profile-xp.html

comments | Add comment | Report as Spam


"rename user profile xp" posted by ~Ray
Posted on 2007-12-15 15:13:19

rename folder in unix call folder linux call folder linux command rename folder unix rename folder vbscript call folders rename folders dos rename folders in dos call folders linux rename folders os x rename folders windows xp rename font rename fonts rename create element with javascript rename fraction rename fractions rename fractions as decimals call freeware rename from rename from list rename ftp rename game files psp rename group of files rename groups call hard control call hard control letter rename hard drive letters rename hard control mac rename hard control os 9 rename hard control os x call hard control windows xp call hard control xp rename hard drives call back up call icon rename image call visualise files rename image php call images rename in dos rename in linux call in unix rename inbox call inbox in outlook 2003 call inbox outlook rename inbox outlook 2000 rename inbox dbx call dilate rename dilate of sql server call ipod call ipod files call ipod in itunes rename ipod itunes call ipod mini rename ipod name call ipod shuffle call ipod shuffle windows rename ipod windows rename it call it 3.0 call it 3.05 call it as call it freeware rename it mac call it software rename it sourceforge rename it to call itunes songs rename earn control call log file rename desire file rename long file name rename long register names rename long filename call desire filenames call machine call man rename many files call many files at once call know call master transfer rename move rename mp3 call mp3 automatically rename mp3 cddb rename mp3 register rename mp3 files rename mp3 files software rename mp3 free call mp3 freedb rename mp3 id3 rename mp3 schedule rename mp3 tag rename mp3 tags call mp3s call multiple rename multiple file extensions call multiple files rename multiple files at once rename multiple files dos call multiple files in unix rename multiple files in windows rename multiple files in windows xp rename multiple files linux rename multiple files unix rename multiple files windows rename multiple files windows 2000 rename multiple files windows explorer rename multiple files windows xp rename multiple files xp rename multiple folders rename music files call my computer icon rename my documents rename my documents folder rename my network linksys rename mysql database rename mysql database phpmyadmin call ntuser rename ntuser dat call oracle call oracle column call oracle columns call oracle database rename oracle database delay rename oracle datafile call oracle datafiles call oracle list rename oracle instance rename oracle schema rename oracle delay call oracle delay column call oracle delay name rename oracle tables rename oracle tablespace call oracle user call os x call os x computer call personal folders rename personal folders outlook call photo rename photo files rename photo with date time rename photos rename conceive of call pictures rename process call program rename schedule files rename program files directory rename program files folder call cycle bin rename recycle bin icon windows xp-home edition rename cycle bin in windows xp call cycle bin in xp call recycle bin registry rename cycle bin sp2 rename cycle bin win xp rename recycle bin windows call recycle bin windows 2000 rename recycle bin windows xp call cycle bin winxp call recycle bin xp call remote printer vb script rename risc os call sas call compose call server rename server 2000 rename server 2003 rename server 2003 domain rename server exchange call server exchange 2003 call server transfer 5.5 rename server linux call server label rename server sql rename server sql 2000 rename server sql server rename server sql server 2000 call several files call several files at once rename shell rename bomb script call shortcut call shortcut key rename shortcut windows rename show showstopper rename software rename software freeware call sql database call sql databases rename sql server rename sql server 2000 call sql server 2000 database rename sql server computer rename sql server computer name rename sql server database call sql server database name call sql server instance rename sql server microsoft rename sql server label rename sql server table rename sql table call sql tables rename sqlserver call sqlserver database rename sqlserver instance call ssid rename start button call go away button in windows xp rename go away button registry call start button windows xp call go away button xp rename go away menu call start menu windows xp rename go away menu xp call stored procedure call synonym delay call syntax rename system folder rename system folder windows xp call system folder xp rename system folders rename delay rename table in mysql call delay in oracle rename delay in oracle 9i rename table in sql call table in sql server rename table in sqlserver rename table mysql rename table oracle rename table oracle 8i call table oracle 9i rename table oracle sql rename table sql call table sql oracle rename delay sql server call delay sql server 2000 call delay sqlite call table sqlserver call tablespace rename tablespace in oracle call tablespace in oracle 9i rename tablespace in oracle9i call tablespace name rename tablespace oracle call tablespace oracle 9i rename tag call tag v3.2 rename tags call the file call the cycle bin rename the go away button rename to call to lowercase call to mp3 call token livejournal rename tokens call drive rename tools rename unix rename unix dominate rename unix commands call unix directory rename unix register call unix files rename unix folder rename unix server call user call user account rename user account active directory rename user account linux rename user account script call user account vbscript call user be win2k call user account windows 2000 rename user account windows xp rename user account xp rename user accounts rename user active directory call user directory call user directory xp rename user folder rename user folder documents and settings call user folder windows xp rename user folder xp rename user in oracle call user linux call user profile call user compose folder call user compose in windows xp call user profile windows 2000 rename user profile windows xp rename user profile xp call user profiles rename user windows xp call user windows xp home call user xp call user xp home rename users rename users in active directory rename utility call vanilla warm call variable rename variable in sas rename variable sas rename variables in sas call variables sas call virtual directory rename virtual directory iis call virtual machine call vlan procurve rename vsam rename window system folder rename window xp administrator rename windows 2000 domain rename windows 2000 domain controller rename windows 2003 domain call windows 2003 domain controller call windows 2003 domain label rename windows folder rename windows folder xp rename windows system folder rename windows system folder xp rename windows system folders rename wrigley rename wrigley field rename your files call your ipod call zip register rename zip files rename+ call+table+sql+server rename4u renamed renamed african countries renamed as renamed biologics renamed cities renamed device drivers renamed into renamed invalid pelt name.

Forex Groups - Tips on Trading

Related article:
http://mp3-player-headphone.blogspot.com/2007/11/rename-user-profile-xp.html

comments | Add comment | Report as Spam


 

 




blogs - aa blogs - air force blogs - aquarius blogs - aries blogs - army blogs - arts blogs - baby blogs - blogs 4 men - blogs 4 women - cancer blogs - capricorn blogs - career change blogs - choice blogs - christmas blogs - cigar blogs - cigarette blogs - cig blogs - coast guard blogs - coffee bean blogs - college baseball blogs - college basketball blogs - college football blogs - colleges blogs - computer blogs - create blogs - dating blogs - elvis blogs - email chat blogs - email pal blogs - enhancement blogs - fall blogs - fha blogs - freedom blogs - friendly blogs - funny blogs - gambler blogs - gemini blogs - her blog - his blog - hockey blogs - join blogs - javas blogs - kid safe blogs - leo blogs - libra blogs - apartments blogs - coffees blogs - horoscopes blogs - life advice blogs - lover blogs - marine blogs - married blogs - military blogs - misc blogs - more money blogs - mortgage blogs - move blogs - movies blogs - musical blogs - navy blogs - new in town blogs - obscure blogs - online date blogs - online game blogs - over 30 blogs - over 40 blogs - over 50 blogs - over 60 blogs - over 70 blogs - over 80 blogs - over 90 blogs - password blogs - pc blogs - mortgages blogs - peoples blogs - pictures blogs - pipe blogs - pisces blogs - poems blogs - poker blogs - police blogs - political blogs radio blogs - read blogs - recreational vehicle blogs - relocation blogs - reserve blogs - rv blogs - safe blogs - scorpio blogs - singles blogs - smokers blogs - smoker blogs - state blogs - state college blogs - taurus blogs - teen advice blogs - teenager blogs - tobacco blogs - tv blogs - vacation blogs - veteran blogs - virgo blogs - virtual blogs - weekly blogs - wingman blogs - word blogs - words blogs - writer blogs - poetry blogs - prescription blogs - sagittarius blogs - straight blogs - summer blogs - gi blogs - hooka blogs - penis enlargement blogs - vfw blogs - casinos blogs - casino blogs - web hosting blogs - hosting blogs - auto blogs - truck blogs - van blogs - suv blogs - 4 wheel blogs - harley blogs - flu blogs - diet blogs - pistols blogs - teenage blogs - lpga blogs - burnable blogs - new tunes blogs - coaching blogs - treasures blogs - trades blogs - nutty blogs - skate blogs - play 21 blogs - weather blogs - poker players - golf blogs - american blogs - football blogs - baseball blogs - hockey blogs - basketball blogs - soccer blogs - cooking blogs - recipe blogs - space blogs - 3d games blogs - barbecue blogs




the move oracle archives:

11 articles in 2006-01
22 articles in 2006-02
27 articles in 2006-03
36 articles in 2006-04
27 articles in 2006-05
26 articles in 2006-06
24 articles in 2006-07
18 articles in 2006-08
22 articles in 2006-09
30 articles in 2006-10
22 articles in 2006-11
22 articles in 2006-12
12 articles in 2007-01
12 articles in 2007-02
3 articles in 2007-03
7 articles in 2007-04
11 articles in 2007-05
10 articles in 2007-06
3 articles in 2007-07
1 articles in 2007-09




next page


move oracle