Toad Help.....

[tommy]

Bhayya I am new to toad....soo.how to [color=#000000][font=Calibri][size=1]run AZ-SMY-YPC-RPT-TBL-DEV and make sure the data is populated and matches with current date.[/size][/font][/color][font=arial, sans-serif][size=3]
[size="3"][color="#000000"][font="Calibri"]Then store it to AZ-SMY-YPC-RPT-TBL.and also [/font][/color][/size][color=#1F497D][font=Calibri][size=1] check that AZ_LOAD_SMY_YPC_FNL_RPT_TBL PROCEDURE has run and AZ_SMY_YPC_FNL_RPT_TBL also updated. Idhi toad lo cheyali.....[/size][/font][/color][/size][/font]

[tommy]

Bhayya I am new to toad....soo.how to [color=#000000][font=Calibri][size=1]run AZ-SMY-YPC-RPT-TBL-DEV and[size=5] make sure the data is populated and matches with current date.[/size][/size][/font][/color][font=arial, sans-serif][size=3]
[size=5][color="#000000"][font="Calibri"]Then store it to AZ-SMY-YPC-RPT-TBL.and also [/font][/color][color=#1F497D][font=Calibri] check that AZ_LOAD_SMY_YPC_FNL_RPT_TBL PROCEDURE has run and AZ_SMY_YPC_FNL_RPT_TBL also updated. Idhi toad lo cheyali.....[/font][/color][/size][/size][/font]

[pinky123]

[CheGuevara]

Okka mukka kuda ardamkaledu

[tommy]

Taod lo tables update ela cheyaliu..........I mean run a procedure and see that the data has been updated in the table and store it in another table....

[Cheeta]

endi nuvvu dba na?

[tommy]

developer ni....

[Cheeta]

[quote name='tommy' timestamp='1373232351' post='1303928776']
developer ni....
[/quote]
sare [img]http://2.bp.blogspot.com/-9PeskG3_8l8/T4J7_6jEF4I/AAAAAAAADGk/Oh9TqmpqwWw/s1600/brahmi+baboi+GIF.gif[/img]

[tommy]

idea undha....

[Cheeta]

[b]Data Pump Overview[/b]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Note: This Toad feature is only available in the commercial version of Toad in either the Professional Edition or with the optional Quest DBA Module. [/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]The Oracle data pump is an import/export utility added in Oracle 10g. It is significantly faster and more efficient at loading large volumes of data than the standard import/export utilities. [/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Key differences between the two import/export engines are as follows:[/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Import/Export[/background][/i][/size][/font][/color][list]
[*]Runs on the client machine
[*]Accesses files on client machine
[*]Transfers data across SQL*Net
[*]Modal utilities (cannot initiate a process and then detach)
[*]Works with any version of Oracle client
[/list]


[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Data Pump[/background][/i][/size][/font][/color][list]
[*]Runs on the database server
[*]Access files on the database server
[*]No data transfers across network
[*]Non-modal utilities (can initiate a process and then detach)
[*]Works only with Oracle clients version 10g and up
[/list]


[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Because data pump client processes can detach from a session running on a server, you can close the import/export execution window without killing the job. The import/export will continue. [/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Note: The data pump engine generates files that are incompatible with the old import/export utilities. This also means that the Toad Export File Browser cannot be used to open or review data pump generated export files. [/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Data Pump Requirements[/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]You must have read/write permissions to the export directory to use the data pump. Local directories must be shared, have read/write permissions and be indicated by the network path. By default, the Data Pump parameter file is stored in the Toad installation directory (C:\Program Files\Quest Software\Toad for Oracle).[/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]In addition, you must have the import/export utilities in your client Oracle bin directory. Some 10g installations may not automatically install these utilities. The utilities required are:[/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]IMPDP.EXE is the Data Pump client import utility[/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]EXPDP.EXE is the Data Pump client utility[/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]Note: These utilities are not the same as the old import/export utilities. If you need to import data from an older version of Oracle, you will need the old utilities. (See Import Utility wizard and Export Utility wizard.)[/background][/i][/size][/font][/color]

[color=#333333][font=Tahoma, Calibri, Verdana, Geneva, sans-serif][size=3][i][background=rgb(242, 246, 248)]The paths for these utilities are stored in the Toad.ini file. You can view and change them from View|Toad Options|Executables. If the Import/Export Utility Wizard is opened and no path has been specified for the export utility, Toad will search for the path and enter it automatically, if it exists.[/background][/i][/size][/font][/color]

[img]http://2.bp.blogspot.com/-9PeskG3_8l8/T4J7_6jEF4I/AAAAAAAADGk/Oh9TqmpqwWw/s1600/brahmi+baboi+GIF.gif[/img]

[tommy]

Toad loo literally ela upload lo kavali..repu office nenu cheyali anduke....

[tommy]

ltt

[Cheeta]

ltt

[MeetFriendz]

tommy bhayaa .... if the procedure is already in the database then follow the below procedure .... i am not that good using toad though i rather use command line .......

[color=#575757]In TOAD's schema browser you can go to the procedures tab - right click on the procedure in question and choose execute procedure - a window should pop up, where you can give optional parameters - the rest should be almost self explanatory [/color]

[raaj]

nuvvu clear ga adugu ...adigindi clear ga ledu....

neekem kavali adi step by step clear ga chepu....

i can help you