PATSTAT - ORACLE loading scripts

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.

Fr3dY
Posts: 16
Joined: Mon Oct 17, 2016 8:57 am

PATSTAT - ORACLE loading scripts

Post by Fr3dY » Mon Oct 17, 2016 3:31 pm

Hi,

I'm sharing the scripts I wrote for loading PATSTAT into ORACLE.
Please try and give some feedback, I hope it works well for you.

PATSTAT 2016 SPRING Edition:
http://s000.tinyupload.com/?file_id=379 ... 9578337902

PATSTAT 2016 AUTUMN Edition:
http://s000.tinyupload.com/?file_id=602 ... 5081572352

PATSTAT 2017 SPRING Edition:
http://s000.tinyupload.com/?file_id=081 ... 1982664037

PATSTAT 2017 AUTUMN Edition:
http://s000.tinyupload.com/?file_id=033 ... 3807538127

PATSTAT 2018 SPRING Edition:
http://s000.tinyupload.com/?file_id=004 ... 8648935206

PATSTAT 2018 AUTUMN Edition:
http://s000.tinyupload.com/?file_id=109 ... 7999310554

PATSTAT 2019 SPRING Edition:
http://s000.tinyupload.com/?file_id=822 ... 7128870693

Don't forget to take a look at the README files before trying!


Regards,
Last edited by Fr3dY on Tue May 21, 2019 8:35 am, edited 13 times in total.


Fr3dY
Posts: 16
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Tue Oct 31, 2017 4:12 pm

Updated: Added scripts for Patstat 2017 Autumn Edition


Fr3dY
Posts: 16
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Tue Apr 24, 2018 3:22 pm

Update: Added scripts for Patstat 2018 Spring Edition


EPO / PATSTAT Support
Posts: 150
Joined: Thu Feb 22, 2007 5:33 pm

Re: PATSTAT - ORACLE loading scripts

Post by EPO / PATSTAT Support » Wed Apr 25, 2018 10:35 am

Many thanks.
:)
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Fr3dY
Posts: 16
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Mon Nov 12, 2018 5:16 pm

Update: Added scripts for Patstat 2018 Autumn Edition


GROW.R3
Posts: 2
Joined: Wed Feb 20, 2019 12:27 pm

Re: PATSTAT - ORACLE loading scripts

Post by GROW.R3 » Wed Feb 20, 2019 12:37 pm

Good Mornings,
There is a different way to receive PATSTAT 2018 AUTUMN Edition - Oracle Script, such as e-mail?
It is impossible for me to download it from tinyupload for security reasons.
The TinyUpload.com site is blocked by our proxy due to its poor reputation.
Regards.


Fr3dY
Posts: 16
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Thu Feb 21, 2019 9:11 am

GROW.R3 wrote:
Wed Feb 20, 2019 12:37 pm
Good Mornings,
There is a different way to receive PATSTAT 2018 AUTUMN Edition - Oracle Script, such as e-mail?
It is impossible for me to download it from tinyupload for security reasons.
The TinyUpload.com site is blocked by our proxy due to its poor reputation.
Regards.
Hi,

Send me a private message with your email address.
Just in case, I've uploaded it to https://ufile.io/uy57w - maybe this one is not blocked for you.




Regards,


Fr3dY
Posts: 16
Joined: Mon Oct 17, 2016 8:57 am

Re: PATSTAT - ORACLE loading scripts

Post by Fr3dY » Fri May 17, 2019 3:49 pm

Update: Added scripts for PATSTAT 2019 Spring Edition


EPO / PATSTAT Support
Posts: 150
Joined: Thu Feb 22, 2007 5:33 pm

Re: PATSTAT - ORACLE loading scripts

Post by EPO / PATSTAT Support » Fri May 17, 2019 6:44 pm

1 day after release !
Fantastic, that was quick :D
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


GROW.R3
Posts: 2
Joined: Wed Feb 20, 2019 12:27 pm

Re: PATSTAT - ORACLE loading scripts

Post by GROW.R3 » Tue Jul 02, 2019 3:22 pm

Fr3dY wrote:
Fri May 17, 2019 3:49 pm
Update: Added scripts for PATSTAT 2019 Spring Edition
Could you do the same for the new version you made for PATSTAT 2018 AUTUMN Edition?
Or can you tell me how to send you a private message to your email address?

Regards


Post Reply